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 :slight_smile:

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

5 Likes

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.

1 Like

Please also request Zapier to add new features like that. :slight_smile:

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.

1 Like

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

1 Like

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

2 Likes

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.)

image

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

That’s all :slight_smile:

2 Likes

@Fabian wow great guidance. Thanks🙌