Google Forms

with google forms modules in make, 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/ http //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 https //www integromat com/en/help/replacing legacy modules with new modules refer to the google forms api documentation https //developers google com/forms/api/reference/rest for a list of available endpoints make's use and transfer of information received from google apis to any other app will adhere to google api services user data policy https //developers google com/terms/api services user data policy connect google forms to make to establish the connection in make log in to your make account, add a google forms module to your , 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 platform project client credentials for more information, see the create and configure a google cloud platform project for google forms section docid\ gzto4temxzn5hwbx60czv 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 and add more google form modules if your connection needs reauthorization at any point, follow the connection renewal steps here https //help make com/connect an application#o qjq create and configure a google cloud platform project for google forms to connect to make 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 log in to the google cloud platform https //console cloud google com/ using your google credentials on the welcome page, click create or 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 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 open the left navigation menu and go to apis & services > library search for the following apis google resource manager api and google drive api click the relevant api, then click enable configure your oauth consent screen for google forms to configure your oauth consent screen in the left sidebar, click google auth platform 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 click get started in the overview section, under app information , enter make as the app name and provide your gmail address click next under audience , select external for more information regarding user types, refer to google's exceptions to verification requirements documentation https //support google com/cloud/answer/9110914#exceptions ver reqts under contact information , enter your gmail address click next under finish , agree to the google user data policy click continue > create click create oauth client in the branding section, under authorized domains , add make com and integromat com click save 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 in the data access section, click add or remove scopes , add the following scopes, and click update > save 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 a window to manually enter scopes publishing status testing if you keep your project in the testing status, you will be required to reauthorize your connection in make 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 https //support google com/cloud/answer/13463073?authuser=1\&visit id=638718595933013017 1855034908\&rd=1 for the app or to connect to your unverified app currently connecting to unverified apps works in make, 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 https //support google com/cloud/answer/10311615#zippy= create your google forms client credentials to create your client credentials in google auth platform, click clients click + create client in the application type dropdown, select web application update the name of your oauth client this will help you identify it in the platform in the authorized redirect uris section, click + add uri and enter the following redirect uri https //www integromat com/oauth/cb/google/ click create click the oauth 2 0 client you created, 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 make build google forms after connecting the app, you can perform the following actions ai ai module builder (beta) instruct make ai module builder google forms module to create quizzes, update questions, collect and analyze responses, or even build survey forms fi eld description connection select an account to connect to an existing account or create a new connection task this field lets you instruct what the module should do in a simple text format you can map any inputs you need directly in the task description safety level protected – this option allows the module to use the read action only it can only retrieve data, not write, replace or delete it in this mode, feasibility and code review checks are done in the background to flag potentially problematic behaviors normal – this option allows the module to use all actions read, write, update, and delete in this mode, feasibility and code review checks are done in the background to flag potentially problematic behaviors unrestricted – this option allows the module to use all actions – read, write, update, and delete it still runs feasibility and code review checks but won't block execution you are allowed to perform actions even if they are risky and can't be undone 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 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 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 https //developers google com/chart/interactive/docs/querylanguage 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 entered will 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