Introduction
This automation makes you able to insert the output straight into a Google Spreadsheet.
Depending on where you put this “Create Spreadsheet Row” step, either at the end
or after a specific step, you will get the output's result of the above.
Make sure you have Connect your Google Sheets account. ☝️
When configuring the step
From an entirely new Google Spreadsheet
- Simply create a spreadsheet by going to https://sheet.new/
- In the configuration integration's step, click the dropdown arrow to select your Account “Click here to choose a Google Sheets account”
- Finally, in the configuration parameters, simply put the
- Google Sheet Spreadsheet Id - the spreadsheetId in your URL
https://docs.google.com/spreadsheets/d/THIS_ID
You need to extract THIS_ID
from the URL in order for it to work.
- Sheet Name - the sheet name to use, by default
Sheet1
; cannot be empty. By sheet, google means tab.
Note: You do not need to create columns from an empty spreadsheet. They will be automatically created for you.
From a Google Spreadsheet already created
- Put the ID of this spreadsheet
- Then, if you prefer to consolidate all the data in a new tab, enter the exact tab name from your existing Spreadsheet.
Alternatively, if you wish to append rows to a spreadsheet tab that already has data, ensure that you use the same header keys in your spreadsheet. Headers refer to the names of each column you want to populate.
We advise you take a look at the output variable keys in the following tooltip in
your workflow and copy/paste them in your spreadsheet headers to avoid errors:
If you have an input column called first_name, you need to add first_name in the first row header.
We strongly advise you to respect this variable_name convention, it'll make data aggregation more easy.
If you require assistance, feel free to reach out to our support team! 🚀