API Credentials for Google Forms

Step-by-step guide (no technical knowledge required) to obtain your Google “Client ID” and “Client Secret” and connect Google Forms with Botize. At the end, you’ll be able to authorize your Google Forms account to automate tasks.

Connect Google Forms to Botize

1. 1

   Open https://console.cloud.google.com in your browser. Sign in with your Gmail account.

2. 2

   Click on the project selector (top, near the logo). In the window that opens, click “New Project”. Give it a name (for example, “Forms Connector”) and click “Create”.

3. 3

   Open the project selector again. If your new project is not selected, click on it to activate it.

4. 4

   In the left menu, go to “APIs & Services” → “Enable APIs and Services”.

5. 5

   Click the “Enable APIs and Services” button at the top.

6. 6

   In the search box, type “Google Forms API” and press enter.

7. 7

   From the results, find “Google Forms API” and select it.

8. 8

   Click the “Enable” button.

9. 9

   In the left menu, go to “APIs & Services” → “OAuth consent screen”. Click “Get started”.

10. 10

    You will be asked to enter an app name. You can use “Botize Google Forms”.

11. 11

    You will be asked to provide an email address. You can select the default one from the dropdown.

12. 12

    Click the “Next” button.

13. 13

    You will be asked whether the audience is internal or external. Select “External”. Click “Next”.

14. 14

    In the “Contact information” field, select your email again and click “Next”.

15. 15

    Check the box to accept the user data policy and click the “Continue” button.

16. 16

    Click the “Create” button.

17. 17

    Click the “Create OAuth client” button.

18. 18

    In “Application type”, choose “Web application”.

19. 19

    In “Name”, enter something like “botize google forms”. In “Authorized redirect URIs”, add exactly: https://botize.com/callback/gforms . Click “Create”.

20. 20

    A window will appear with your credentials. Copy the “Client ID”.

21. 21

    Now obtain the “Client Secret” by clicking on the OAuth client you just created. You will find the Client Secret at the bottom right, in the “Client secrets” section. Copy it using the copy icon next to it.

22. 22

    In the left menu, go back to “APIs & Services” → “OAuth consent screen”.

23. 23

    Now go to the “Audience” section in the left menu.

24. 24

    Click the “+ Add users” button in the “Test users” section.

25. 25

    You will be asked to enter the email of the person who will have access to automate tasks with Google Forms. Enter it and click “Save”.

26. 26

    Go to https://botize.com, log in with your account. Go to “Apps” and search for “Google Forms”. Click on the Google Forms icon.

27. 27

    Click “Add a new profile”. In the form, paste the “Client ID” and “Client Secret” you just copied from Google Cloud.

28. 28

    Click “Authorize” in Botize. A Google window will open. Choose the Google account you want to connect.

29. 29

    Since the app is only for you, you will see a warning that it is not verified. Click “Continue”.

30. 30

    Select “Allow all” (or check all boxes shown) and click “Continue”/“Allow”.

31. 31

    Back in Botize, you will see your Google Forms profile connected.