Active with remarks |
---|
This application needs additional settings. Please follow the documentation below to create your own connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). More. |
With Google Forms modulesThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More in Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. More IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. More, 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 | |
---|---|
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. |
To establish the connection in Boost.space Integrator:
-
Log in to your Boost.space Integrator account, add a Google Forms moduleThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More to your scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive. More, and click Create a connection.
-
Optional: In the Connection name field, enter a name for the connection.
-
Optional: Switch on the Show advanced settings toggle and enter your Google Cloud Console project client credentials. For more information, see the Create and configure a Google Cloud Console project for Google Forms section below.
-
Click the Sign in with Google.
-
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.
To connect to Boost.space Integrator using your own client credentials, you can create and configure a project in the Google Cloud Console.
To create a Google Cloud Console project:
-
Log in to the Google Cloud Console using your Google credentials.
-
In the top menu, click Select a project > New project.
-
Enter a Project name and select the Location for your project.
-
Click Create.
-
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.
To enable the required APIs:
To configure your OAuth consent screen:
-
In the left sidebar, click OAuth consent screen.
-
Under UserCan use the system on a limited basis based on the rights assigned by the admin. More Type, select External.
For more information regarding user types, refer to Google’s Exceptions to verification requirements documentation.
-
Click Create.
-
Fill in the required fields with your information.
-
In the Authorized domains section, add
make.com
andintegromat.com
. -
Click Save and continue.
-
In the Scopes page, click Add or remove scopes,add the following scopes, and click Update.
-
https://mail.google.com
-
https://www.googleapis.com/auth/drive
-
https://www.googleapis.com/auth/userinfo.email
-
https://www.googleapis.com/auth/spreadsheets
-
-
Click Save and continue.
-
Optional: If your project will remain in the Testing publishing statusCreate statuses for each module separately to create an ideal environment for efficient and consistent work. More, add test user emails on the Test usersCan use the system on a limited basis based on the rights assigned by the admin. More page, then click Save and continue.
Note: If you are using custom appsCreate your own custom apps to be used in the integrator engine and share them with users in your organization. with publishing state, Testing, then you must set up the access tokenThe API token is a multi-digit code that allows a user to authenticate with cloud applications. More NOT TO be forced to re-authenticate every week after expiration.
However, our tests have shown that it is currently possible to set your Publishing Status to In Production to avoid this weekly re-authentication.
For more information, see Setting up OAuth consent screen. To set up app token and authentication, see Using OAuth 2.0 for Web Server applications.
To create your client credentials:
-
In the left sidebar, click Credentials.
-
Click + Create Credentials > OAuth client ID.
-
In the Application type dropdown, select Web application.
-
Update the Name of your OAuth client. This will help you identify it in the console.
-
In the Authorized redirect URIs section, click + Add URI and enter the following redirect URI:
https://integrator.boost.space/oauth/cb/google/
. -
Copy your Client ID and Client secret values and store them in a safe place.
You will use these values in the Client ID and Client Secret fields in Boost.space Integrator.
After connecting the app, you can perform the following actions:
Form
-
Search Forms
-
Create a Form
-
Get a Form
-
Update a Form
Note: For ItemItems are rows in records (order/request/invoice/purchase...) Changes, Location refers to the item’s position on the list of all form itemsItems are rows in records (order/request/invoice/purchase...). 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
is1.23
andA2
is=A1
and formatted as currency, thenA2
will return$1.23
.Unformatted value: Values will be calculated, but not formatted in the reply. For example, if
A1
is1.23
andA2
is=A1
and formatted as currency, thenA2
will return1.23
.Formula: Values will not be calculated. For example, if
A1
is1.23
andA2
is=A1
and formatted as currency, thenA2
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
is1.23
andA2
is=A1
and formatted as currency, thenA2
will return$1.23
.Unformatted value: Values will be calculated, but not formatted in the reply. For example, if
A1
is1.23
andA2
is=A1
and formatted as currency, thenA2
will return1.23
.Formula: Values will not be calculated. For example, if
A1
is1.23
andA2
is=A1
and formatted as currency, thenA2
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