Creating a new project from a template and updating row information using Zapier
I am currently using Zapier to automate the creation of a project sheet once an initiative gets approved on a log. The current configuration is the following:
- New initiatives are captured into a sheet called "Initiatives Log" through the use of a form
- Approval of the initiative is captured on a column called "Approval Status"
- Zapier uses this change to create a sheet from a template called "Project Template". that contains a header section (rows 1 to 10) to capture project information (project sponsor, project manager, start date, required by date, total budget, etc...)
- The project manager assigned to the initiative has to go into the recently created project and populate the first rows by copying the information from the "Initiatives Log".
I was wondering if someone in the community has been able to automate step 4. I have tried several zap configurations, however, I always get stuck when trying to update a row on a sheet that was created as part of a previous step on a multi-step zap. The "New row update" action in zapier requires a row ID and I have not been able to find a way to capture the Row IDs of the rows from the recently created sheet.
Thanks in advanced!