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.
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.