I have a make workflow with minor issues. I have provided the JSON export for reference. Essentially my workflow is supposed to pick values from a master Google sheets and then create a new Sheet and send it as weekly reports to recipients.
Problem with me workflow is
-
Module ID 25: I am updating the Sheets while aggregation which is wrong because if any of the further operations fail then those fields are already updated with X. Having this module at the very end did not work for me because I wasn’t able to determine the rows to update
-
Module ID 23: Currently I have to manually create a spreadsheet in a shared drive folder and manually update the ID here for it to send it as a separate Sheets attachment to recipients. I want to know if there is a way to incorporate adding anew sheet and use it’s ID to supply to bulk add rows. I have tried doing it with in built modules but didnt work. Especially the one where it creates a sheet with an existing template.
Hopefully I have provided enough info to get ideas with my situation and I appreciate all the help.
Send weekly reports to receipients.json (45.9 KB)