I’m trying to set up a trigger such that I scrape data from 1 google sheet to another google sheet once a day.
The only way I can do this is to get todays date via =TODAY() in a cell.
When the date changes, the corresponding figure in =TODAY() will also change.
But will this trigger my zap? Seems to not for some strange reason...
Question
Does =TODAY() in Google Sheets trigger as an update to the row?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Perhaps you can describe you use case more for needing to move data between 2 GSheets.
Perhaps post screenshots about how your Zap steps are configured.
Maybe consider using an operational database app such as Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations
Airtable has built in Automations, Views with Filters that can be used to trigger Zaps, and integrate well with Zapier.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.