My thoughts was to use the Drive module to copy an existing spreadsheet ID (since they are the same each time). Then map the JSON data to that same sheet.
The google sheet has 4 sheets,
The first sheet will map the form submission details.
The second sheet will map the JSON data from the ChatGPT module.
Once I copy sheet, how would I be able to essentially start mapping to that sheet? I’m stuck at this point and not sure how to access the new spreadsheet to input the data.
I would suggest completing the Make Academy before jumping into building this complex scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
I dont have an official working prototype at the moment, since this was a demo concept I am proposing to the client.
My question at the moment is should I be duplicating their existing spreadsheet template, and then populating with the output data?
I had someone mention I should use the create template module, but that won’t include all the styles they have added to their spreadsheet e.g header bg colours, column widths etc.
