I have a zap that puts a cognito entry into a google sheet as the first available row. Is there a way to have the create a row at the end and insert there?
Cognito create new row in sheets at bottom
Hi
Make sure there are no empty rows in the GSheets and the Zap will always add a new row at the bottom.
Thank you,
Thanks!
Check out this help article: https://zapier.com/help/doc/how-to-set-up-your-google-spreadsheet-to-work-with-zapier
To use Google Sheets with Zapier you need to set up your spreadsheet in a very specific way.
If you don't set up your spreadsheet this way, you're likely going to have problems.
Pay close attention.
These are the things you'll need from your Google Sheet to optimize it for use with a Zap:
- The first row must have titles for any column headers you want to be able to see in your Zap.
- The second row must have content for any columns you want to be able to see in your Zap.
- There can be no completely blank rows before the end of your spreadsheet.
As an alternative, perhaps check out Airtable: https://zapier.com/apps/airtable/integrations
Hi
As Troy pointed out, if you’re going to have people interacting with the Google Sheet that will have data added to it, that’s really not going to be ideal at all. Something like Airtable, which he mentioned, would be a better solution for what you described.
Another possible option is to look into using Google Sheets’ IMPORTRANGE function to bring the data from that sheet into another one, where others could manipulate freely. But if those same folks are modifying data, then something like Airtable is definitely better option.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.