Best answer

Is it possible to have dynamic google spreadsheet files, so that actions are taken on a different one every month?

  • 6 November 2020
  • 1 reply

my zap

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 andywingrave 7 November 2020, 16:38

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +9

Hello! This is a great question and is actually surprisingly simple using Zapier’s storage functionality.

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

Then finally: