Make scenario: google sheets 'add a row' can't see newly created tabs

Question

My scenario creates a new tab every month for leads, then an add a row module should write into it. The module only lists the tabs that existed when I set it up. How do you point it at a sheet that doesn't exist yet?

sophia.dasy · Answer

The sheet list in that module is loaded once and cached. Reopen the module and refresh the sheet name dropdown, or switch the field to map and type the tab name yourself. Are you creating a new tab every run? If so, mapping the name from an earlier step is the only way it'll keep up.

smith_ads · Answer

If the scenario creates the tab itself, put a short sleep module between that step and add a row. Sometimes the new tab isn't ready for a few seconds and the first write fails.

Make scenario: google sheets 'add a row' can't see newly created tabs

Leave A Reply

2 Answers