GEO-FENCING TRIGGERS: Send Webhooks to Add/Edit Rows or Trigger Actions Based on Location

[GreenFlux]

Want to add a row or trigger an action when a user enters/exits a certain geographical area?

App-creators can capture the user’s location using the HERE() function, but the app-user must still SAVE & SYNC the app to submit data.
AppSheet does not support live streaming of location or geo-fencing triggers.

Using Integromat and the AppSheet API, App-Creators can trigger a webhook to their app when users enter/exit a defined zone.

• The user must install the free Integromat app and enable location services on their mobile device.
• Note: There is no AppSheet-Specific Integromat app, but the HTTP app will work.

Once configured and enabled on a user’s device, app-creators can set up a ‘Scenario’ in Integromat to send an HTTP request when the user enters/exits a zone.

AppSheet and Integromat both provide detailed documentation on how to format the webhooks.

App-creators can add/edit/delete a row, or invoke an action based on the webhook formatting.

USE-CASES

• Send Email when delivery arrives without driver<->app interaction
• Auto check-in students or gym members for a class
• Send a text when driver is 1 mile away

---

Full Disclosure: GreenFlux is an Integromat Partner Developer. I am not asking for referrals, and use of this integration does not require a paid plan. This info is to benefit the AppSheet developer community.

[Ami]

Hi
Does it require any special paid plan with appsheet?

[GreenFlux]

Hi @1111. I’m using the AppSheet API (inbound to app) on the Pro Plan ($10/month).

I’m not sure if the API is available on the Premium Plan ($5/month).

The pricing guide actually looks like the REST API only works with a Business Plan, but I’ve been using it with the Pro Plan for a while now. I guess the guide is outdated.

[Grant_Stead]

So, the integromat app is free?
Do the users need to sign in?
Could they use their AWS Cognito login?

[GreenFlux]

Hey @Grant_Stead!

• Yes, the iOS/Android Integromat app is FREE!
• And the free version of the web service supports all apps/integrations they offer, with a 1000 operations/month limit.
• Yes, the mobile user would have to be signed into the Integromat mobile app, using the same Integromat account that configures the scenario (or a linked account- paid plans only).

I’m not sure on the AWS Cognito login. You can create an account with Google, Facebook, GitHub, or with your email.

[Grant_Stead]

Thanks for the info!
I guess how does that scale? If I have 50 users, they all log in with my account?

[GreenFlux]

Grant_Stead:

I guess how does that scale? If I have 50 users, they all log in with my account?

Yes, for the Integromat mobile app, all the users would login with your one Integromat account. So all of their usage would count against your free 1000 operation/month limit.

There is also an option to create ‘Organizations’ in Integromat, so you can share and collaborate on Scenarios with other Integromat users (paid plans only).

[Fabian_Weller]

Thank you @GreenFlux for pushing Integromat. Your example is perfect!
In my opinion Integromat is much better than Zapier and AppSheet should consider building an own App in Integromat, like they did for Zapier.

[GreenFlux]

Fabian:

In my opinion Integromat is much better than Zapier and AppSheet should consider building an own App in Integromat, like they did for Zapier.

Yes, Integromat is SO much more powerful than Zapier! There are tons of other use-cases that could supplement AppSheet, like retrieving a POST response or adding GET requests.

[School_Bus]

OMG!! I feel like a giddy little school girl reading this. I’m looking at the integromat android app, and I can’t change the location, how do I do that? How do I set up a geofence? Did you do it inside of integromat or did you do this with appsheet?

Seriously… I’m in awe right now.

[GreenFlux]

School_Bus:

I’m looking at the integromat android app, and I can’t change the location, how do I do that?

In the Integromat Mobile app:

Settings>GPS>Track Location = ON
Settings>GPS>Areas>Add New

• Set diameter
• Choose enter and/or exit as trigger
• Name & Save area

I think you have to be at the actual location because it only lets you set a diameter and not a center lat/long.

In Integromat Website:

• New Scenario, Add iOS app & HTTP app
• Link the iOS module to the name of the GPS area you created
• Link that to the HTTP request module using the AppSheet API to edit desired sheet

[School_Bus]

So I figured out how to set the location. When you go to add a location, there is a search icon at the top and it will allow you to put in a new address.

I’m a bit bummed that I can’t push new addresses to the application, make the app less useful. It’s also weird, I can seem to add locations, but I can’t remove them.

It’s so close!!! I can feel it, I need to think about this and see if I can make it work the way I need it to.

[Douglas_English]

I’m interested in adding this feature to my app, as my valets rarely clock in an out accurately it’s a hassle to get them to go back and do it, if this could happen automatically it would mean a world of difference for my operation. Do I have to figure out how to do this myself or can someone help me with it?

[School_Bus]

@Douglas_English I’m working on an app that fixes this. Let me know if you want to see it, I’m in the tail end of development, so having a few users would be great, shoot me a message if you want to try it out.

[School_Bus]

It’s working now, so if anyone wants to shoot me a message, I’d be happy to let you try it out.

[DenysSepulvida]

Olá, gostaria de mais informações

[JULIAN21989]

Hi dear I Want try it 

[Ryan_Wagner]

I know this is an old thread, but it is an incredibly compelling idea. Is anyone aware of a video detailing the steps in the OP? I am new to the API world. I went as far as setting up an Integromat (now known as "Make") account, put the app on my phone, and set up a geo-fence area. Everything after that is beyond me...