Scripts, scripts, scripts!

[Darren_Murphy]

I don’t think you need a script for this.
Assuming that I understand correctly, here is how it can be done:

• In table A:
  • create a template column that concatenates the values of each column you need to use to compare
• In table B:
  • create a similar template column as per table A
• In your Glide Form:
  • create User Specific Columns to temporarily store the input values
  • create a 3rd template column to concatenate these values. The format should be identical to the template columns you created in Table A and Table B
  • now create two relations. One joining to Table A (call that rel-A), and the other joining to Table B (call that rel-B)
  • if rel-A is not empty, you have a duplicate of a row in Table A
  • if rel-B is not empty, you have a duplicate of a row in Table B
• the logic to decide which tables to write to based on the state of the relations can be handled within a custom action sequence

[Antonoff]

Thanks

create a template column that concatenates the values of each column you need to use to compare

it is e column A +B + C = value for compare?

[Darren_Murphy]

When I create template columns for this purpose, I usually do something like:

{name}:{age}:{sex}

And then I use replacements to substitute the actual values for each row.

[Eric_Penn]

Is it possible to have a google script detect new email from gmail and import a csv to sheets from an attachment? I was using Zapier but after 6+ months my zap is suddenly now broken and I’m in need of a fix…FAST! Trying Integromat I think I was close but couldn’t quite get it.

[Drearystate]

I am unsure if you can do this with scripts. Which email service are you using? I use outlook and thankfully Microsoft in all of their wisdom allows VBA programming in outlook so I have VBA running code to download all attachments and emails to different folders so that I may use them in Power Bi and Glide.

[Eric_Penn]

Currently using Gmail but I could switch emails if it provides a solution. Without the ability to automate this process my business is imploding

[Darren_Murphy]

@Eric_Penn

Is it possible to have a google script detect new email from gmail and import a csv to sheets from an attachment? I was using Zapier but after 6+ months my zap is suddenly now broken and I’m in need of a fix…FAST! Trying Integromat I think I was close but couldn’t quite get it.

I’ve never tried it, but I’m sure it’s possible. But way way easier with Integromat, I’d imagine.
I really try to avoid scripts when there is an easier way…

[Eric_Penn]

I think I am close with Integromat but I don’t know what to put here under CSV??

[Darren_Murphy]

Why are you watching a GDrive folder?
I thought you were trying to parse an email attachment?
What does your full scenario look like?

PS. We’re starting to cross the line into Integromat support, here…
PS2. I’m not an Integromat expert by any stretch of the imagination (someone like @V88 might be able to offer better advice)

[Drearystate]

@Robert_Petitto is really good @ Integromat as well

[Eric_Penn]

I would like to have two scenarios…one that watches GDrive and one that watches Email.

The GDrive scenario helps me if I need to troubleshoot or manually do something. The email scenario for regular automation.

Full scenario 1 Watch for new email > Parse CSV to sheets
Full Scenario 2 Watch Drive new file > Parse CSV to sheets

I started work on Scenario 2

[V88]

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.

[Robert_Petitto]

I’m getting better!

[Eric_Penn]

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 correctly, however I have not been able to test yet.

[Pablo_Sanz]

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

[ehdubya]

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.

CSV

[Darren_Murphy]

@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?

Using App Script with a JSON API

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 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…

[Eric_Penn]

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

[V88]

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.

[V88]

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!