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 would like for us to list off scripts here to help each other out. I will post most of my scripts that I still use to hopefully be an example of this.

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 [Screen Shot 2021-03-01 at 10.51.58 AM] It appears I have all the other modules and fields filled out correctly, however I have not been able to test yet.

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 text value or a file. Aggregators Create CSV Merges selected text items ...

[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 put together a tutorial on working with API’s, so here it is. It’s my first tutorial, so please be gentle pray Whilst there is an app at the end of this, the app is not the main focus of the tutorial, so don’t expect to be impressed by that. The main focus is to give a gentle (?) introduction to Apps Script, and demonstrate how it can be used to interface with an API endpoint. I’ve tried to break down and explain t…

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 [Screen Shot 2021-03-01 at 1.06.53 PM]

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	7167	January 26, 2021
Delete Row for "Create new action..." workflows Ask for Help actions	41	3282	January 25, 2021
New Row in Spreadsheet for Every User Ask for Help	52	3814	September 26, 2020
Exceptions in deleting rows in a spreadsheet Ask for Help	67	1771	January 17, 2022
OnChange trigger Ask for Help	29	7535	January 3, 2022

Scripts, scripts, scripts!

Related topics