Seeking Advice: Handling API Errors and Providing Real-Time User Feedback

[mwit000]

Hello!

I'm currently working on an AppSheet app that submits data via a form to a Google Sheet.

It's set up in the way AppSheet appears to have intended: the data source is Google Sheets with specific columns, the users are able to submit data via a form view. This works as intended - a new record is added. From there, an automation is triggered (on adding a new row to our sheet), which sends this data to an external API, which then processes the submission and updates our backend system. The integration is working well overall.

The Challenge:

However, I’m running into an issue with handling errors from the API and providing real-time feedback to the user. Specifically:

• If the API returns an error (e.g., 500 server error) or if the user attempts an action that is "illegal" (based on the API logic), there’s currently no way for the user to know that something went wrong.
• Since the API call is handled by an automation after the data is submitted to the Google Sheet, the user doesn’t receive immediate feedback. They assume everything went fine, even if the API failed.

What I’m Looking For:

I'm trying to figure out a way to:

1. Notify the user in real-time if the API submission failed or was rejected.
   
   
2. Display a status (e.g., "Success," "Failed," "Pending") in the AppSheet app after the form is submitted, based on the response from the API.

I’ve considered:

• Adding a status column in the Google Sheet to be updated based on the API response, but this doesn’t seem to provide real-time feedback in the app, as the column is updated after some time by an automation, possibly after being read by AppSheet.
  
  
• Redirecting users to an intermediary view that could show the status, but integrating the API response into this flow in real-time is challenging. Also, again - there are no guarantees that it will be displayed after it gets updated and not before.
  
  
• Using some automation configuration magic: I suppose I could just send a notification to the user that he submitted invalid data - but is that my only option?

Has anyone tackled a similar issue or found a creative workaround to handle API errors and provide real-time feedback to the user within AppSheet? Any advice, suggestions, or best practices would be greatly appreciated!

Thanks in advance for your help!

[WillowMobileSys · Accepted solution]

AppSheet does not presently support Request/Response type interactions directly with external API's.  It can only send the data TO the external API but has no way to capture and process any responses.

EDITED:  It has been pointed out below that AppSheet DOES support return payloads.  Not sure how I missed this.  I don't know how it works or exactly the limitations but will get familiar with it soon!

You can also implement a Google App Script which returns a response.  This is supported.  So your automation calls the script, the script make the external API call, grabs the response and parses that into a return value to AppSheet.  You can then have subsequent steps in this automation that react the returned value from the script.

The next best option is to have the external API submit its response to the AppSheet API.  But this requires you to be able to implement that ability on that external service which is typically not the case.

A third option it to use an integrator service such as Make.  These services have connectors to many API's.  If one of them has a connector to the external API, then you may be able to build a process that can submit to the external API, parse the response and then submit to AppSheet API.  I do know that Make has integrations with AppSheet API.