Hi Everyone Does anyone know how to link Google Calendar and Appsheet together, whilst at the same time having all the data recorded from Gcal and Appsheet onto Google Sheets? So all 3 platforms run in unison and I can edit everything and make updates. I believe I might need a special code to use …

You can connect the gCal as a data source with your app. Then the app is connected with the gCal. The more challenge is the gSheet that it works 100% in both ways. Some of it you could probably done with IFTTT.com recipe but does it work 100% in both ways, I’m not sure. GAS is of course one option a…

could a solution like this help me? - https://www.youtube.com/watch?v=MOggwSls7xQ I havent got a coding background and i have been just trying different things to see what I come up with and trying to use A.I. to help me. I just need a bridge between the platforms and i suspect appscript is going t…

“all i need it the name/title, start date, start time and location” Do you need it only for one direction.. like only when it’s created in gSheet?

The backstory is - I run a team of electricians that visit homes and appsheet is the core management platform for me to reach them in the field. there are 2 apps in question: 1 - the homeowner books a convenient time via the appsheet app I send directly to them, and that specific appsheet app is co…

Also, instead of going through the google servers. Can you not use appsheet servers as a point of reference instead?? So Appsheet is the master controller? That why I ask if Appsheet specifically has a expression I can use somewhere so appsheet writes to Gcal>and then appsheet writes to Gsheets simu…

So.. in your case, would it be enough to write only the event from the gCal to GSheet?

Thats the short way around it but I lose the functions I have interconnected in Gsheets for things that branch off. I want to try getting this under control for business growth and not having delegated planners switch between systems. I just want them to be concerned with 1 focal point and share a G…

Let me play with it, I have an idea..

Actually, you can control this with AppSheet. The main point here is that because you are able to identify what is the “Row ID” for the gCal event, you are also able to update the gCal event with an action.. and the opposite. So.. when the client creates the gCal event, add an action that writes th…

The only thing that doesn’t work.. if someone modifies the event directly in gCal, the app is not able to identify this as it’s not happening in the app itself. Meaning.. the gSheet is not then updated. If that’s needed as well, you could read it with a scheduled Bot like once in an hour.. or use th…

Google Calendar, Google Sheets and appsheet integrations

AppSheet AppSheet Q&A

HarelK September 14, 2024, 8:38pm 17

Can I ask for this app too?

Topic		Replies	Views
Google Calendar two-way sync? AppSheet Q&A admin , automation , expressions	3	37	February 16, 2022
Creating a calendar of events in Appsheet that puts them on Google Calendars automatically Tips & Tricks admin , automation , databases	8	733	March 13, 2026
Google calendar and syncing with app form AppSheet Q&A ux	4	31	December 22, 2021

Google Calendar, Google Sheets and appsheet integrations

AI Suggested topics