You can use data from Google Calendar in your app to view and manage details for a meeting or event, including:
- Title and description
- Creator and attendees
- Start and end times
- Google Meet link
- Web link
Use data from a Google Calendar as described in the following sections:
- Add a Google Calendar as a data source
- Use the Google Calendar data in your app
- Typical usage patterns
First, you must add a Google Calendar as a data source.
- Go to appsheet.com and sign in to your account.
- Select My Account in the top navigation bar.
- Select Sources.
- Click + New Data Source.
- Enter a name for the data source in the field provided.
- Click Google Calendar and follow the prompts to authenticate.
Your Google Calendar account is now available as a data source for tables in any of your apps.
To use Google Calendar data in your app, add a new table to your app, select the Google Calendar data source you previously added, and select one of the calendars in your account.
Like all other tables, calendar entries may be added, updated, or deleted depending on the table permissions chosen.
The Google Calendar API always provides dates and times in US/English locale, in the form:
MM/DD/YYYY Consequently, it's important to ensure the AppSheet table for the Google calendar is also marked as having the English (United States) locale. For more information, see Locale support in AppSheet. This has no effect on how dates are shown in the app; the format of dates in the app depends only on the locale of the user's device or browser.
Consider the following using Google Calendar data in your app:
- Most users will use the primary Google Calendar.
- To view calendar data, it's common to use add a virtual Thumbnail column to create a text icon image, using the app formula:
- AppSheet apps are best suited for viewing and modifying calendar entries that are associated with existing data in other tables; they are not meant to replace custom calendaring applications.
The most common associations between another table and a calendar table are via the
Attendees columns. For example, consider an app with two tables:
Customers (with a column called
Calendar. We have provided two built-in formula functions to easily construct virtual columns in the
Customer table that model related
GCAL_MEETINGS_FROM("Calendar", [Email])- Use in the app formula of a virtual column to find meeting requests sent by each customer. The generic structure is
GCAL_MEETINGS_WITH("Calendar", [Email])- Use in the app formula of a virtual column to find meeting requests where the customer is an attendee. The generic structure is