Integromat: OCR, Push Notification, Geolocation, and more

I want to share a very cool web service to do things you cannot do with AppSheet.
Here is a litte Introduce.

Here is what I’m doing:


If a new PDF file is stored in Google Drive, it does the OCR and sends the Text to my AppSheet App. It also converts the multi page PDF into single JPG files and saves them into Google Drive Subfolder. I can open the JPG files then in my AppSheet App.
If a new JPG file gets stored into Google Drive, it’s just doing the OCR and sends the Text to my AppSheet App.
With this I can use OCR also for PDF files.



With the Integromat App on Android, you can create Buttons. When a Button is pressed, it sends a message to my AppSheet App. It also sends a Push Notification to my Windows Chrome Browser.



When you add a new Address in your AppSheet App, it gets converted into Lat&Long via Google Maps and sends it back to your AppSheet App. Now you can create a Slice to show only locations that are 5 km away from you.

I would like to hear about your ideas

@Phil please consider an AppSheet Integration for Integromat, like we have in Zapier.

14 19 3,709
19 REPLIES 19

Hi @Fabian
Thank you for sharing this tool, I never know. Just watch a few recording, but it looks awesome. My app is basically running on MS SQL, but surprisingly they do have native connector to it.

Such awesome no-code platform will just enhance the power of Appsheet, and extend the capabilities.

Time/era for no-code surely has come.

Anyway, I will look into this tool to consider what sorts things we can do with Appsheet.

Cheers.

Swoopy
Participant V

Please also request Zapier to add new features like that.

Bahbus
Participant V

I just stumbled across those guys randomly yesterday, and though I can’t think of a good way to use this service (for myself) at the moment, I was planning on saving this since it looks waaaaay better than Zap in terms of ease of use.

Another usecase for Integromat:

@Fabian must one have an Appsheet Business Subscription for Integromat to send to Appsheet? I assume it uses the Appsheet API

I see there is a Feature Request on Integromat for a native integration into Appsheet https://www.integromat.com/en/requests/new-app-requests/p/appsheet

Hi @Henry_Scott I have a PRO Account and AppSheet API is working wonderful

Ok great. So unlike Zapier that has Appsheet as an App, you use an HTTP Webhook in Integromat to post to the Apsheet API?..using the Pro Plan to confirm

@Fabian may I ask that you share your knowledge on the HTTP configuration of Integromat?. What exactly is the format that you pass to the Appsheet API. I see you also have an option for JSON in Integromat. You are not using the JSON option, but the HTTP option?

In URL you use the format https://api.appsheet.com/api/v2/apps/{appId}/tables/{tableName}/Action described here.

In Headers you paste in Name: ApplicationAccessKey
And in Value: The Application Access Key you find in your App under MANAGE --> INTEGRATIONS --> “IN: from cloud services to your app”.

Then you set
Body type = Raw
Content type = JSON

In Request content you write your JSON like explained here.

In my case it is:
(Key and Status are values that are coming from the first Webhook.)

2X_3_35eac02b6cb0f348becd67fe0ef52c28ff6e44dc.png

{
      "Action" : "Edit",
      "Properties" : {
        "Locale" : "de-DE",
        "Timezone" : "W. Europe Standard Time",
      },
      "Rows": [
      {
        "Key" : "{{8.Key}}",
        "Status" : "{{8.Status}}"
      }
      ]
    }

That’s all

@Fabian wow great guidance. Thanks🙌

Converting PDF into JPG with Integromat

I learned that PNG is much better than JPG. The file size is smaller with better quality and faster loading time. That’s why we added another step: CloudConvert - Optimize a File.
The steps are:

Convert PDF into PNG (you can also set the width and height)

Optimize the PNG

Ami
Participant V

@Fabian hi, I’ve been using Integromat for some time now and there is a problem that seems to happen a lot with google sheets at least, I got for instance a string array (1,2,3) and when tried to split it got nothing. After a long while I’ve used google sheets text to columns option and then it turned out that the “1” was actually not a number but rather a text, the “2” and “3” were numbers. I’m not sure if it’s Integromat or my google sheet, but It makes it harder to use the data. Have you ever encountered something like that yourself?

Thanks

Hi @1111 no I didn’t but I can suggest you to contact the Integromat Support. They are very fast and very helpful.

ehnz
Participant IV

Hello, I would be interested if anyone has used the Integromat Appsheet integration to invoke a task inside appsheet - like send a notification

Actually, yes you can! AppSheet recently added integration into Integromat. Here is a list of possible modules you can make to interact with your app.

Hello, thanks, \have you ever tried the ‘Actions’ - Invoke an Action? I can’t seem to get it to work

Woohoooo! That’s cool. I didn’t know that.
@Liz_Lynch I’m pretty sure this was not announced in the release notes?

I saw this announced somewhere that’s how I knew. Not sure where that was. It could have been off-platform. I’ll announce this in the Resources section so a wider audience sees it.

Top Labels in this Space