I would like to have automatically create a new spreadsheet every month like “Andjelka Petrovic 2” next month and “andjelka Petrovic 3” the month after and make the zap perform the action(making google sheets entries for every google calendar entry) on the new file. How would you do that(if it requires coding, what is the code)?
Best answer by andywingraveView original
Hello! This is a great question and is actually surprisingly simple using Zapier’s storage functionality. https://zapier.com/help/doc/how-get-started-storage-zapier
So what you need to do is create a first zap that would create your spreadsheet and store the value of your spreadsheet ID in Zapier Storage as a key value pair.
Now we want to add a step in our existing zap that gets the value “Current Spreadsheet” before we choose which spreadsheet to update. Then we can map that value in the task from your screenshot