Hi,
I made a Google Spreadsheet and connected to my Discord server.
It has to refres the date fro a cell every day (the date will refresh automaticly in the Google Spreadsheet).
Evenn trigger: New or Updated Spreadsheet Row in Google Sheets
Event: Send Channel Message in Discord
Trigger Column: A
id: 2
row: 2
So in my spreadsheet A2 is the date I want to update every day and it will send a message to the channel. It works until I close the tab that this Zap is in. After that everything went wrong and wasn’t able to get the right data. Not to mention that is in not too instant, took 3-5 mins to update, but for me it is not a big problem.
Other strange thing for me if I press Load more in the Test Trigger I can find Spreadsheet Row A-E now but have only one row. How can i delete these? They have previous dates but for testing I needed to change them.