I am trying to create an excel workbook or upadte an existing one based on info submitted on a google form.
Basically I have 2 fields in a google form I will use to create a workbook with the name of those 2 fields.
If a workbook already exists with that name, I want to update the already existing workbook with that name in the folder, but if the workbook does not exist, then I want to create it and then add a row to it with the form submission information.
I think the best step to do this is:
1.- Trigger when google form submitted
2.- Create new excel spreadsheet
Add error handler
If success:
Add row to created spreadsheet
If fail:
Add row to existing spreadsheet
I have managed every step except the fail part.
The issue I am encountering is that I don’t know how to choose fields for the existing workbook to put the form info in, let me show a screenshot:
On Success, I can assign values to columns:
But on error I have to manually input the spreadsheet name (I will input the name that failed the creation the previous step) and I also need to input the Worksheet name manually. Problem is now I cannot assign form values to rows I know exist on that file:
I cannot choose the file from the dropdown list because new form submissions will create new files in the future, so this needs to be dynamic.
Also, a last question.
Is it possible to do this without the error handler? I only want to create this 1 zap and I am in the trial period, I don’t want to pay for the subscription for a single zap.
Thank you for reading, hope I expressed myself clearly.