How to create a Zap that adds rows to different tabs in Google Sheets based on the month

Hi ​@Ilaria Zap 

Some options:

• Use Airtable instead of GSheets
  • You can create 1 View per Month, all in the same Table, thus no need for paths or extra logic
  • Views can have Filter conditions
    • e.g. Month = January
  • Help: https://support.airtable.com/docs/getting-started-with-airtable-views
• Use the concept of a lookup table to make the Zap dynamic
  • Help:

     

Hi there, ​@Ilaria Zap! 👋

Were you able to solve things by switching to Airtable or using a lookup table as Troy suggested? 

Want so ensure you’re all set so let us know whether you need any further help at all. 🙂

​@Ilaria Zap 

It can be done with a code block and understanding the google sheet identification. 

I had written a long post with the code but it just gets put into moderation. 

You need to use the Google Sheet ID rather than it’s name. You can grab these easily from the google sheet url or underneath the sheet name in the zap configuration. 

 

You need to then find today’s date extract the month and match it with the google sheet ID. I have written code for you to do this but my post went to moderation where they disappear. If you would like the code let me know and I’ll DM you. 

You then enter that sheet ID into the step by clicking the three dots and selecting custom

Then grab the variable from the code step as the worksheet name

 

This will allow you to add data to the right month of the year and not have to switch over to Airtables.

I may try and post separately the code.
​​​​​​​

I hope it helps and if you’d like the code let me know.