In the first zap, I create a spreadsheet every hour in the future and, as you can see in the screenshot, I store its ID in the name “mykey” which I then want to retrieve in another zap to perform some row addition triggered by a new google calendar entry. The problem is that these new rows are not created on the latest spreadsheet, but the ID where they get entered is always the first one when I created the zap, whereas I thought it would update every time the zap creates a new spreadsheet.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Storage by Zapier help articles: https://zapier.com/apps/storage/help
Hi
Is this when the Zap is running live or when you’re testing the Zap? If it’s during testing, you’ll always have to test the Google Sheets trigger, then the Set Value test and then the Get Value step.
I also noticed that your keys in the screenshots don’t match (not sure if those are the actual ones or just an example). But if it’s the real keys then you’ll want to make sure they match :)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.