Is there a way for Appsheet to detect email responses, as a way to track task progress on App?

[Lana]

Is there a way for Appsheet to detect email responses, as a way to track task progress on App?

[LeventK]

@Lana
Unfortunately that’s not possible with a Google Apps Script support. A time triggered Google Apps Script can check your Gmail inbox for some search criteria and do that work.

[Lana]

Thanks LeventK for the quick response, Were just trying to create a task progress status view in our App. Our current process, is that we sent email request for a needed File and the other party attached the file through email response.
What we did with our App, is it sends automatic email for request , and and have the recipient Attached the needed File using the App, so a status change will be triggered and changes the task from Assigned to completed. However, the users refused to do it that way since they feel its more easy to just used the email. So from there we are just trying to find other ways that may be convenient for users…Any other suggestion please…?

[Grant_Stead]

Maybe this here:

Executing a DeepLink action from an Email Silently Tips & Tricks 💡

[STEP-3 | THE ESSENCE] As you have deployed your web-app, you should be having an endpoint URL similar to this: Web-app URL> https://script.google.com/macros/s/AKfycbyYZb6AEV3vf4zKJNrsVxq7vj-Aeqw3mLT_n3vf-gf-2cgEp2E/exec By design of my sample app, I have planned that this URL shall receive 2 parameters/query keys in the URL string. These are: ID: Which is the key column of my sample table Option: Which is the status that I define to pass both to the AppSheet API and the Subscribe Now a…

[LeventK]

@Lana
Are those “other party” official users of your app or are they outsiders? Provided they are official users of the app, then you can send them a deep app link via workflow email which will launch the app and the associated record in edit mode on the form, where they can select and upload their file. Then an UPDATES_ONLY triggered DATA CHANGE or WEBHOOK workflow can change the status.

If they are not official users of the app, create a public app, share the related sheet and table with this public app, create a slice from this table to only show the FILE type column in the form. With the email send the deep app link associated with this public app URL which will allow the users to edit that record but face the file upload part only, upload the file, save the record and change the status via a DATA CHANGE or WEBHOOK workflow.

@Grant_Stead
Do you have any other solution in mind bud?

[Grant_Stead]

I think those are the best appsheet centric options.

[Grant_Stead]

Further, it’s my understanding that appsheet is actively pursuing deeper integrations with Gmail.

[matteolavaggi]

Today AppSheet can easily send dynamic email forms to Gmail account to interact with app views without the need of open or install the application.