Integromat - tried it?

[Zac]

Hi,
Did anybody hear about this before / try it?

Integromat

Airtable Integrations

Integromat gives you the ability to integrate Airtable with many other services.

[Gco]

And the connection is very easy:

[W_Vann_Hall]

I recently built an interface between Airtable and the USPS Address Validation API using Integromat. The parts that were straightforward went swimmingly, and I’m a huge fan of their UI. The parts that weren’t straightforward remain impenetrable. There are fields and variables that go undefined throughout the documentation, and I’m sure there are far more elegant methods of doing what I did — but I couldn’t find decent example code or tutorials to help me muddle through.

Admittedly, comparing Integromat to Zapier in terms of documentary support isn’t really fair — for that matter, comparing virtually anyone to Zapier isn’t all that fair, as Zapier has one of the best technical/technical marketing writing teams ever assembled. That said, Integromat’s recent decision to shutter their support forums and direct their users to the company’s Facebook page instead can only be viewed as an unforced own goal.

[Krisjanis_Dzalb]

Trying to set up Integromat integration for new row in excel table to new record in Airtable. The fetching of records from excel works but I get an error “Value “null” is not a valid record ID.” on Airtable side and can’t understand what I’m doing wrong.
Help?

[M_k]

Hi @Krisjanis_Dzalbe1

Do you have some screenshots of the whole scenario? Also, the individual modules that you are using?

It might help.

Thank you,
Mary K

[Krisjanis_Dzalb]

Tried to run just the airtable module only and the problem occurs with the field which is a link to a record in another table.

[M_k]

Hi @Krisjanis_Dzalbe1

Without being able to see the fields, in the first two modules, it’s a little bit hard to see what field is creating the error.

Hopefully, these two replies will help, together with some screenshots.

Take a look at this post, reply #2:

Sync google sheet to table-Integromat Integrations

I want to be able to link a simple google sheet to a table in Airtable using Integromat so that i can have outside users update, delete, and create records via the google sheet. I started by using the Integromat template for creating and updating aritabel via google sheets and all I can get it to do is create one record and then it uses all the other rows to update the one row it created instead of making new rows. I know this should be very easy but I can’t seem to locate the issue of why it wo…

Also, try this link, post# 21:

Update Records Airtable Base to Airtable Base w Integromat Integrations

@M_k - I’ve attached screenshots of the basic concept I’m trying to accomplish. @Bill.French - Perhaps not, but not sure I can accomplish with just read only rights. Base A contains all of my clients’ information and Base B contains client specific information. Instead of sending links to 75+ different records in Base A, I’ve created a separate Base B with just the one client’s information. They shouldn’t have access to all of the information in Base A. [56%20AM] [28%20AM]

These are screenshots of how your scenario might look like, without the Google Sheet module:

! (upload://f7SBdP1mgJuOtAhHcMMSgzmIe6c.png)

[Krisjanis_Dzalb]

Thanks! I tried it out and it works as long as I leave the linked field empty.
So to localize the question how do I correctly map the linked record field?

[M_k]

Hi @Krisjanis_Dzalbe1

I am glad it works for you.

To fill in that field, try selecting the very small box on top of the field. Once you do that, you should be able to fill in the field.

Mary K

Like this:

[Krisjanis_Dzalb]

Thanks. I did switch the “map” toggle and choose the necessary value from the excel file before and got the error “Value is not a valid record ID”. Even though the value matches a record ID in the linked table.

[M_k]

Hi @Krisjanis_Dzalbe1

What does the value look like? It comes from Excel, correct.

How about the formula? Is it written correctly? Although, it might not be that, unless it’s the unique key.

Did you check to make sure that the value is written correctly, in Excel and Airtable?

You should make sure that the field name from both Excel and Airtable match correctly.

If it has to do with a field value it could be the smallest thing, either a misspelling or an extra space, especially at the end.

I am just trying to think of different things to check.

If you could take screenshots of the value in Excel and in Airtable, that might help. Otherwise I am just kind of guessing.

Did you create a new TIME CREATED field in Airtable? Apparently, Airtable requires this field to process the data.

Did you mention that you had linked tables, (two tables together?). If so, are they linked correctly?

I hope these suggestions might help.

I have had situations that I would spend time clecking everything, sometimes a bunch of times.

Mary Kay