Skip to main content
Question

How to add data to the next available cell in a Google Sheets row with Zapier?


Hi,

Zapier newby here. 

 

Im trying to create an attendance taking automation that adds dates to a Google Sheets Spreadsheet and was wondering:
 

How do I get Zapier to add data to the next available cell within a particular row in Google Sheets?

 

Everything I’ve tried so far just keeps writing over the first cell in the row. 
 

Here’s an example of what I’m trying to achieve:
 


 

Thanks! 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Backbone 

Good question.

GSheets need to be configured in a specific way to be used in Zaps.

Make sure to review the available help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

 


Troy Tessalone
Forum|alt.badge.img+14

@Backbone

Also, I’d recommend using Airtable instead of GSheets.

You can create a relational database by linking records across Tables.

Plus, the better way to structure the data would be to have 1 “Date” record per row, rather than multiple “Dates” per row.