I was helping someone earlier and it occured to me that we do not have a Forum Page dedicated to helpful scripts. Now I know some of us cling to our scripts because they are in some ways what makes our apps great. Well, I use a ton of scripts in my apps and in my daily job and with that being said I…

So in both cases you have a CSV that you need to parse and, I guess, for each row you then add a row to a Google Sheet? Where is the sticky point? I have used Integromat lots but never with CSV.

:slight_smile: I’m getting better!

I am stuck on parse CSV. I’m not sure what to enter under the required field “CSV”? I’m also unclear if this applies… “Hint: If your data comes in binary form, you have to use the toString function to convert it to String.” ▶ Summary It appears I have all the other modules and fields filled out co…

F … you are magicians !!! What would a script be like to read a JSON from a webhook and write it in a new row in the spreadsheet? I’ve been studying it for weeks but I still can’t understand at least the part of the JSON reading :v:t5:

Dunno if you’ve read this yet or not but I’ve had to a few times and I had it bookmarked. There’s a snippet about Parse CSV in there that might help. [image] CSV Getting started with CSV The CSV aggregator and CSV transformer lets you create csv files and parse csv text from a received te…

[image] Pablo_Sanz: What would a script be like to read a JSON from a webhook and write it in a new row in the spreadsheet? [image] Using App Script with a JSON API Community Resources Somebody who shall remain nameless ( @SantiagoPerez - oops) asked me if I could pu…

I did see that thank you. It’s a little above my paygrade. I’m sure this is the section I need only I don’t have anything called “Data” or something similar. ▶ Summary

When you are parsing any form of file, Integromat makes it really simple. Just get the file then dump its contents (e.g. data) into the CSV / JSON / XML field of your parsing module. I am out at the moment but will take a look later in you’re still stuck.

So. What you need to do is add another module in between Watch Files in Folder and Parse CSV. This should be a Download File module. It will download the file to Integromat. You can then use the Data output from this module to feed the CSV input to the Parse CSV module. And all will work as planned! …

[image] Add the new module to download the file [image] Tell it the file to download based on the FileId of the previous module [image] Feed this modules Data output into the Parse CSV module

Scripts, scripts, scripts!

Ask for Help

Darren_Murphy March 1, 2021, 6:07pm 159

Topic		Replies	Views
Google Sheets built-in "On form submit" trigger Ask for Help	61	6737	January 26, 2021
Delete Row for "Create new action..." workflows Ask for Help actions	41	3074	January 25, 2021
New Row in Spreadsheet for Every User Ask for Help	53	3518	January 27, 2024
Exceptions in deleting rows in a spreadsheet Ask for Help	67	1365	January 17, 2022
OnChange trigger Ask for Help	30	7288	January 17, 2024

Scripts, scripts, scripts!

Related topics