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
  • 78 views

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)?

icon

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. 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: