Hey Makers! I can’t seem to find any documentation on the “Gsheets: create new spreadsheet form template” function.
It fails because it states “Your file MUST contain at least one tag for this module to work.”
What do they mean by TAG? as far as I’m aware, I have no tagging column on this particular spreadsheet.
Any help would be greatly appreciated!
Ok solved the tag by wrapping one of the column texts in {{example}}.
My question now is, how do I occupy the newly created spreadsheet with new data from a from which is triggering the new spreadsheet action
1 Like
Hi @Dave_Legion ,
you twisted your last sentence but I think you meant typeform data?
Can you use the “Update row” module?
It highly depends on the format of your google sheets
Hope it helps!
Best,
Richard
Hi @Richard_Johannes thanks for your response. I worded that terribly, sorry.
Let’s try it again. I’m using MAKE to create a ‘new spreadsheet from template’ triggered from a new typeform submission. Which works.
The expected behaviour was for the typeform data to occupy/fill that newly created templated spreadsheet with that data. It did not.
Would you have any ideas about how you would go about doing this?
Hopefully, that’s a little clearer! Thanks in advance
Enrique
September 18, 2022, 5:37pm
5
II am stalled at the same point.
May you explain in more detail how did you solved this? How did you wrap one of the column texts in the template spreadsheet?
What did you do in make to connect with that tag?
Thank you in advance
Dave_Legion:
rs! I can’t seem to find any documentation on the “Gsheets: create new spreadsheet form template” function.
It fails because it states “Your file MUST contain at least one tag for this module to work.”
What do they mean by TAG? as far as I’m aware, I have no tagging column on this particular spreadsheet.
Hi there,
in at least 1 cell in the spreadsheet you are copying (the template) you need to define a tag using the {{Tag Goes Here}} syntax.
Then when you run the module for google sheet from template, you will need to populate that variable with something. So maybe the easiest thing is in the template put somewhere {{Date Copied}} and then in your make scenario just pass along ‘now’ (maybe formatted).
Hope this helped!
1 Like