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)?
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.
https://zapier.com/shared/4a5686b071e9019ee651c5c1338187eeee9b96fc
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
Then finally:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.