Skip to main content

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

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


@ashley.g 

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


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