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:
I would like to hear about your ideas
@Phil please consider an AppSheet Integration for Integromat, like we have in Zapier.
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.
Please also request Zapier to add new features like that.
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.)
{
"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
@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.
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.