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.
Can you please share screenshots of the full set up of each zap.
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 :)
Hi
I wanted to check in with you on this one, since we didn't hear back after our last message. Did you still need help here or were you able to resolve things? Please let us know :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.