Hey there hyd?
I just started using make to automate some tasks at my intern job and the 1st thing Im trying to do is automate a google sheets update that is basically copy and paste from a excel worksheet
sometimes nothing happens and somethings I get a error like “Collection can’t be converted to text for parameter”. Can you pls help me?
Hi @Lucas5 and welcome to the Make Community!
You likely need to get a better understanding of bundles, arrays, iterators and aggregators.
I’m not sure what you’re getting back from Excel, but it’s likely more than one row. This means you need to add each row one at a time or use the “Bulk add rows” feature of Google Sheets to add many rows at the same time.
I would encourage you to take some time to go through the Make Academy courses to familiarize yourself with the concepts I mention above.
L
Thanks for your time!
Gonna check it out
