Google Sheets, Calendar and Productivity Apps
Google Sheets
Add a row to a spreadsheet for every entry.
- In Google Cloud console, create an OAuth client (web application), enable the Google Sheets API, and add the Redirect URI shown in FormGlut.
- In Global Settings › Integrations › Google Sheets, paste the OAuth client ID and OAuth client secret, save, then click Connect.
- In the form’s feed, paste the Spreadsheet URL, choose the Sheet (tab), and set the Columns: a column header and the field for each.
- Turn on Add entry ID and date to add those columns too.
The same Google OAuth client can be reused for Google Calendar and Google Drive.
Google Calendar
Create a calendar event from each entry, for example for bookings.
| Feed setting | What it does |
|---|---|
| Calendar | The calendar to add events to. |
| Event title / Description | Smart tags work. |
| Date field | The form’s date field. |
| Start time field (empty = all-day event) | A time field. |
| Length (minutes) | Event length. |
| Location | Text or a field. |
| Invite the email in field | Sends a calendar invite to the visitor. |
Airtable
- Connect: a Personal access token.
- Feed: choose the Base and Table, and map the Fields.
Notion
- Connect: an Internal integration secret. Share your database with the integration in Notion.
- Feed: choose the Database, map the Properties, and optionally write the Page content.
Trello
- Connect: your API key and Token.
- Feed: choose the Board, List and Labels, and set the Card title, Description and Due date field.
Asana
- Connect: a Personal access token.
- Feed: choose the Workspace and Project, and set the Task name, Description, Due date field and Assignee email.