So I made this zap, where when a cell in a specific column is changed, it send the change to the same column in the same row in the database. (the database has 3 options it can receive)
The test shows it works ok, but I do not see any chance to the database.
I do have another question though - is Zapier checking the database for new rows on set time intervals? and can these be changed?
@Megaman
The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger
The triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this. After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods. This process takes about 3 minutes overall.
While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.
@Troy Tessalone Thanks.
How does this work when it’s from mydql to sheets?
@Megaman
All of the MySQL Zap triggers are scheduled. (see bottom screenshot)
Scheduled Zap triggers can take from 1-15 minutes to trigger depending on your Zap plan. (see top screenshot)