Question

Airtable New Record populates in Sheets & new worksheet created daily

  • 11 October 2022
  • 4 replies
  • 26 views

Hi There!

 

I’m curious how anyone would approach the following need that I’m trying to solve with Zapier. 

 

  1. New Worksheet created in a Google Sheet at the start of the day
  2. Add a new row(s) from an Airtable View into the new worksheet
  3. Repeat everyday

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @ashley.g 

Good question.

How many records can there be in the Airtable View?

Hi @Troy Tessalone 

 

Thanks for your time & attention!

 

There would never be more that 150 records in this view in a day. Everyday the list will refresh to 0, then slowly populate throughout the day. Another way to explain it: I’m trying to set up an automation to fill in the metadata for an action that happens throughout the day into a sheet that then gets downloaded as a .CSV at the end of the day and submitted by EOD. The sheet would need to refreshed to 0 at the start of a new day. 

 

Thanks!
Ashley

Userlevel 7
Badge +14

@ashley.g 

Why not trigger the Zap when a record enters the Airtable View to then send the data to the GSheet tab?

Userlevel 7
Badge +8

Hey @ashley.g 👋🏾, did you need any help setting up Troy’s suggestion? Happy to walk you through!