Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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.
 

Welcome to the Community, @Dav111! 

When you say it stopped working when you closed the tab the Zap was in, are you saying that while you were manually pulling in new test data from the Google Sheet and testing your Zap it was working, but when you switched the Zap on and let it run it didn’t work as expected? 

It sounds like you might be wanting to update a single cell in the spreadsheet (Column A, Row 2) everyday and only have updates to that particular cell trigger the Zap. But the way that the New or Updated Spreadsheet Row trigger works is that it will trigger for any new row or change to existing rows. So if you’re adding/updating information to other rows of the spreadsheet, these will also trigger the Zap.

To get around this, you could potentially add a Filter to your Zap to check that the row that triggers the Zap is always row 2. This would mean that a message is only posted in Discord when row 2 is updated. 

It’s normal for previously loaded test samples to remain in the Zap Editor. It’s not possible to delete these samples but if you load in newer samples they will start to be replaced by the newer samples - Change the test data in your Zap trigger

Hopefully the suggestion above is helpful. :)

Terms & Conditions