Inputs
You don't need inputs for this automation.
It will fetch data from a spreadsheet, based on a header (the first row).
Parameters
-
Google Sheet Spreadsheet Id - the spreadsheetId in your URL
https://docs.google.com/spreadsheets/d/THIS_ID
You need to extractTHIS_IDfrom the URL in order for it to work.
- Sheet Name - the sheet name to use; cannot be empty.
Remember that you need to use headers in your spreadsheet.
Configure Mapping: How to map a column coming from your Google Sheet to provide the inputs required at the next step?
You need to activate the manual mapping as below and put your column name in the text area.
Click on the three dots > enable Manual mapping > Enter a mapping value.Common Error
-
Wrong Spreadsheet ID: Ensure you use only the ID, not the entire URL.
-
Wrong Sheet Name: The name must match exactly. By default, it’s usually "Sheet1". Not the name of your Spreadsheet.
- "Spreadsheet Name" is for the whole file, and "Sheet Name" is for each individual tab or worksheet within that file.
-
Wrong Mapping with the Next Step: If the column input you’re providing is different from the column name required for the next step, you’ll need to perform manual mapping as explained above.
If you're unsure how to fix the issue, don't hesitate to contact support for assistance.