Google Forms Entry to AppSheet Entry Automation

djnguyen · 04-10-2025 09:22 AM

Hello AppSheet Community,

Need some assistance here! I currently have an AppSheet that mimics a little "career portal" where REQUISITIONS are created and posted and SUBMISSIONS are sent in. My SUBMISSIONS are linked to the REQUISITION table via a REQ ID - which I use in AppSheets as a Reference. It's been an awesome tool until my IT department has decided to disable external sharing of AppSheets due to security concerns.

Is there any AppSheet automation or bot that will accept Google Form responses and auto-create an entry in AppSheets ? Google Forms is not blocked for external sharing and I could just have my users submit information and a resume file through there.

Any assistance would be greatly appreciated!

CANA-IT

Yes. I use a Google Form, with My App.
Just wanted to post that real quick to give you some hope.
Let me get you the details on how I did it.
It is a little drawn out.

CANA-IT

To Accomplish this.
I used a Appsheet DB.
I added the specific sheet where the Google Form sends the data into the App Data Section.
I added a Bot:
1. Bot is on a schedule (every hour) it goes and looks for data on the form responses sheet
2. If data is found, I run a data action "add new row" to the Main Data base
3. Send email notifying the addition
4. delete the record from the form response sheet.
I hope this helps you out. There is an Appsheet Add-on for GSheet but I didn't need it.

djnguyen

Thank you for sharing! I'll look into it!