Create a spreadsheet from a template module in Google Sheeets throwing error - REOPEN CASE

How To
1

@Michaela

Hello Michaela

I react to the previous discussion regarding this issue

I have same error with value missing.
The problem is that I am using different spreadsheet (10) and according to the filter I choose the right one as template.
I will create new templates and I can t everytime add sheet ID and choose a fake value to replace, it s insane.
Why can t we make a simple copy of the template?
Any solution to get rid of this mandatory option to choose a value to replace?

FYI in my previous scenario I was using google drive copy module, but this module has often error “missing file” because it seems it communicates not very well with make.
That s why I wanted to try google sheet template module

Thank you

2

Hello! Welcome to the Make community.

Can you please let me know what thread you are referring to?

Cheers,

Benjamin

3

Hello

I used same title (just added REOPEN CASE at the end :wink:

Create a spreadsheet from a template module in Google Sheeets throwing error

In parallel I contacted helpdesk regarding this “issue” and they confirmed me that they do not have solution except everytime specifying AND the spreadsheet ID AND SHEED ID with one value to replace.
As I already explained, the google drive copy module often has ERR 500 error and because of this it blocks my scenario, I must manually restart the scenario, thats annoying and that s why I want to get rid of google drive copy module, thia is not stable enough for daily use.

To explain you, I have a scenario to create invoices, I have several templates according to customer country, currencies etc, so I use datastore to store the ID of the spreadsheet and according to filter, it picks the right template and creates an invoice.
with google drive copy module it s easy, I just have to store the spreadsheet ID, with excel module I have to store spreadsheet ID, and sheet ID and value to “replace” (in fact I dont need to replace value so I ask him to put same value)

I manage to make it work but this mandatory request to have a value to replace is kind of weirdo, when you want a template you don t want to replace one value automatically
Becaue of this I need to make my datastore more complicate and to use module SET multiple variable instead of using set variable module.

Thank you