I am trying to create a new google sheet from a template and populating it with multiple (variable) records from Airtable. The problem is that instead of creating ONE sheet with multiple records, it creates multiple sheets, each with one record in them. I tried iterating the records, but then I can designate any of the fields in the table where the array of records reside.
You should add “create a spreadsheet from a template” module before “search records” and after the “search record” module add “add a row” module.
So, I think this will help you.
I will try and revert back
It creates the new sheet and saves it in the right place, as it did before. However, I get an error on the "adding row stage
You have to change the column range from “A1:Z1” to “A2:Z”
it doesn’t give met that option, it only gives the collumns A-Z, A - BZ, A - DZ, etc.
Check whether the sheet name is correct or not.
Also, can you please share the blueprint of your scenario.
Hi, thank you for your reply. Yes, the name of the file and the sheet are both picked up from the creation of the new file from the template. I am not sure what you mean by “blueprint”, could you expand?
Go to three dots and export the blueprint .
Ah, right, thanks
blueprint (1).json (89.4 KB)
You may be dealing with a known Google Sheets API bug here.
Basically, if you have certain characters in the sheet name, you’ll get error trying to update multiple cells (a row), but no problem updating just a single cell.
The only workaround I could find was to rename the sheet and remove the special characters, though not sure exactly which special characters will cause this.
Here’s another thread about this issue.
Hi, thank you for the suggestion. However, the only special character I had was “-”, which after being removed, had no impact. It is a very good suggestion to keep in mind for future google sheets, thanks.
Have you tried hard-coding the sheet name?
Like another member mentioned previously, maybe the sheet name was incorrect / not found.
If you install the Integromat Chrome Dev Tool, it will let you get more details about the error.
Hi, thank you for the suggestion. Unfortunately, hard coding it would negate the purpose of automation as I would have to go in and create the sheet every time and then I might as well just run an export of the AT table. Is the Integromat Chrome Dev tool an extension? I have not heard of it before. Thank you
Yep it’s an extension to chrome. https://www.make.com/en/help/scenarios/integromat-devtool
Once loaded, find the Scenario Debugger which will let you drill down into the actual HTTP requests the module is sending.
I only suggest hard-coding in case for troubleshooting purposes. The error suggests it cannot figure out the sheet name and range from your inputs.
Hi, I figured it out. I had set the module to id the name of the sheet manually. when I set it to select from all, it worked! Thank you for your support @Donald_Mitchell and @Sakshi_agr12
another problem did come up when I put the scenario into the full scenario Pause a scenario waiting for a module to finish before proceeding