Missed the Community Update Webinar? Learn what's coming in the next release & catch up 🤞
Watch recording 🟢
All categories
System
Access management
AI
Appflows - Technical
Billing
Billing and policy
Built-in apps
Business cases addon
Business Intelligence
Business Operations and ERPs
Calendar addon
Commerce
Communication
Community apps
Contacts module
Contracts addon
CRM and Sales tools
Customer Support
Database
Education
Features
File and Document Management
Forms Addon (Legacy)
Getting started with Boost.space
HR management
Internet of Things
Invoices module
IT and Development
language-tools
Lifestyle
Marketing
Marketplace - Overview
Marketplaces
Modules and Addons
News monitor addon (legacy)
Notes addon
Offers addon
Orders module
Other
Pages addon
Policy
Process Management
Productivity
Products module
Projects addon
Records
Spaces
Surveys and Forms
System Settings (for Admins)
Tasks module
Travel
Users and teams
Wall addon
Warehouses addon
Website Building
Work hours addon
Integrations
Apps
Connections
Errors
Functions
Getting started with Boost.space Integrator
Integrator Modules
Mapping
Scenarios
Tools
Tutorials
List of applications
Table of Contents
Active with remarks
This application needs additional settings. Please follow the documentation below to create your own connection.
Redirect url
https://integrator.boost.space/oauth/cb/google

Google Forms

[Important] Important

Any references to third-party products or services do not constitute Boost.space Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Boost.space does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

With Google Forms modules in Boost.space Integrator, you can search, create, retrieve, and update forms and move forms to trash, watch, list, and retrieve responses, and watch, search, add, update, and delete responses in Google Forms.

To use the Google Forms modules, you must have a Google account. You can create an account at docs.google.com/forms/.

To upgrade to a new version of the Google Forms app, you need to upgrade all modules manually by Replacing Legacy Modules with New Modules.

Refer to the Google Forms API Documentation for a list of available endpoints.

[Note] Note

Boost.space Integrator‘s use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy.

Connect Google Forms to Boost.space Integrator

To establish the connection in Boost.space Integrator:

  1. Log in to your Boost.space Integrator account, add a Google Forms module to your scenario, and click Create a connection.

  2. Optional: In the Connection name field, enter a name for the connection.

  3. Optional: Switch on the Show advanced settings toggle and enter your Google Cloud Platform project client credentials. For more information, see the Create and configure a Google Cloud Platform project for Google Forms section below.

  4. Click the Sign in with Google.

  5. If prompted, authenticate your account and confirm access.

You have successfully established the connection. You can now edit your scenario and add more Google Form modules. If your connection needs reauthorization at any point, follow the connection renewal steps here.

Create and configure a Google Cloud Platform project for Google Forms

To connect to Boost.space Integrator using your own client credentials, you can create and configure a project in the Google Cloud Platform.

Create a Google Cloud Platform project for Google Forms

To create a Google Cloud Platform project:

  1. Log in to the Google Cloud Platform using your Google credentials.

  2. On the welcome page, click Create or select a project > New project. If you already have a project, proceed to the step 5.

  3. Enter a Project name and select the Location for your project.

  4. Click Create.

  5. In the top menu, check if your new project is selected in the Select a project dropdown. If not, select the project you just created.

[Note] Note

To create a new project or work in the existing one, you need to have the serviceusage.services.enable permission. If you don’t have this permission, ask the Google Cloud Platform Project Owner or Project IAM Admin to grant it to you.

Enable APIs for Google Forms

To enable the required APIs:

  1. Open the left navigation menu and go to APIs & Services > Library.

  2. Search for the following APIs: Google Resource Manager API and Google Drive API.

  3. Click the relevant API, then click Enable. If you see the Manage button instead of the Enable button, you can proceed to the next step: the API is already enabled.

Configure your OAuth consent screen for Google Forms

To configure your OAuth consent screen:

  1. In the left sidebar, click Google Auth Platform.

    [Note] Note

    If you don’t see Google Auth Platform in the left sidebar, click View all products at the top of it, then pin Google Auth Platform to the sidebar.

    Pin_auth_platform.png

  2. Click Get Started.

  3. In the Overview section, under App information, enter Make as the app name and provide your Gmail address. Click Next.

  4. Under Audience, select External. Click Next.

    For more information regarding user types, refer to Google’s Exceptions to verification requirements documentation.

  5. Under Contact Information, enter your Gmail address. Click Next.

  6. Under Finish, agree to the Google User Data Policy.

  7. Click Continue > Create.

  8. Click Create OAuth Client.

    Create_oauth.png

  9. In the Branding section, under Authorized domains, add make.com and boost.space. Click Save.

  10. Optional: In the Audience section, add your Gmail address on the Test users page, then click Save and continue if you want the project to remain in the Testing publishing status. Read the note below to learn more about the publishing status.

  11. In the Data Access section, click Add or remove scopes, add the following scopes:

    • https://mail.google.com

    • https://www.googleapis.com/auth/drive

    • https://www.googleapis.com/auth/userinfo.email

    • https://www.googleapis.com/auth/spreadsheets

    You can add scopes using:

    • A table with filters:

      gmail_scopes_filter.png

    • A window to manually enter scopes:

      Gmail_manual_scopes.png

    Click Update.

  12. Click Save.

[Note] Note

Publishing Status

Testing: If you keep your project in the Testing status, you will be required to reauthorize your connection in Boost.space Integrator every week. To avoid weekly reauthorization, update the project status to In production.

In production: If you update your project to the In production status, you will not be required to reauthorize the connection weekly. To update your project’s status, go to the Google Auth Platform, the Audience section, and click Publish app. If you see the notice Needs verification, you can choose whether to go through the Google verification process for the app or to connect to your unverified app. Currently connecting to unverified apps works in Boost.space Integrator, but we cannot guarantee the Google will allow connections to unverified apps for an indefinite period.

For more information regarding the publishing status, refer to the Publishing status section of Google’s Setting up your OAuth consent screen help.

Create your Google Forms client credentials

To create your client credentials:

  1. In Google Auth Platform, click Clients.

  2. Click + Create Client.

  3. In the Application type dropdown, select Web application.

  4. Update the Name of your OAuth client. This will help you identify it in the platform.

  5. In the Authorized redirect URIs section, click + Add URI and enter the following redirect URI: https://integrator.boost.space/oauth/cb/google/.

  6. Click Create.

  7. Click the OAuth 2.0 Client you created, copy your Client ID and Client secret values, and store them in a safe place.

    client_id_and_secret.png

You will use these values in the Client ID and Client Secret fields in Boost.space Integrator.

Build Google Forms Scenarios

After connecting the app, you can perform the following actions:

Form

  • Search Forms

  • Create a Form

  • Get a Form

  • Update a Form

    Note: For Item Changes, Location refers to the item’s position on the list of all form items. The very first item is 0, the second item is 1, and so on. To add an item at the very beginning of your form, use 0 as the location.

  • Move a Form to Trash

Response

  • Watch Responses

  • List Responses

  • Get a Response

Legacy

  • Watch Responses in Google Sheets

    Value render option

    Formatted value: Values will be calculated and formatted in the reply according to the cell’s formatting. Formatting is based on the spreadsheet’s locale, not the requesting user’s locale. For example, if A1 is 1.23 and A2 is =A1 and formatted as currency, then A2 will return $1.23.

    Unformatted value: Values will be calculated, but not formatted in the reply. For example, if A1 is 1.23 and A2 is =A1 and formatted as currency, then A2 will return 1.23.

    Formula: Values will not be calculated. For example, if A1 is 1.23 and A2 is =A1 and formatted as currency, then A2 will return =A1.

    Date and time render option

    Specifies how dates, times, and duration should be represented in the output. This is ignored if Value render option (above) is set to Formatted value.

  • Search Responses in Google Sheets

    Value render option

    Formatted value: Values will be calculated and formatted in the reply according to the cell’s formatting. Formatting is based on the spreadsheet’s locale, not the requesting user’s locale. For example, if A1 is 1.23 and A2 is =A1 and formatted as currency, then A2 will return $1.23.

    Unformatted value: Values will be calculated, but not formatted in the reply. For example, if A1 is 1.23 and A2 is =A1 and formatted as currency, then A2 will return 1.23.

    Formula: Values will not be calculated. For example, if A1 is 1.23 and A2 is =A1 and formatted as currency, then A2 will return =A1.

    Date and time render option

    Specifies how dates, times, and duration should be represented in the output. This is ignored if Value render option (above) is set to Formatted value.

  • Search Responses in Google Sheets (advanced)

    Note: For the Filter field, define the search query using the Google Charts Query Language.

    E.g. select * where C = "John" to retrieve all values for the row where the C column is “John”.

  • Add a Response in Google Sheets

    Note: For the Timestamp column, use the following value: formatDate(now;DD/MM/YYYY HH:mm;UTC)

  • Update a Response in Google Sheets

    Note: For the Value input option field, Raw will not parse the values entered by the user and are stored as-is. User enteredwill parse the value as if the user typed them into the UI. Numbers will remain numbers, but strings may be converted to numbers, dates, etc., following the same rules that are applied when entering text into a cell via the Google Sheets UI.

  • Delete a Response in Google Sheets

Other

  • Make an API Call