How to Send Data To Google Sheet
To Send Data To Google Sheet, First Connect the SpreadSheet in Botamation
Click Manage In Google Sheets

Click on Create New

Create a new Google Sheet with the columns and click on Share and copy the link

Provide the name for the spreadsheet and provide the spreadsheet link

How to Connect Google Sheet Action In Flow
Click on + icon and select Actions

In Actions >> Google Sheets

In Actions select Send Data and select the spreadsheet.
Map the custom fields to the google sheet column, Refer the image below


Output Result:
