How do I access advanced setting to connect Google Sheet?

:us: I can’t connect my Google Sheet to Make… I don’t know where to access to paste my Client ID and secret Client. Please


No logro conectar mi Google Sheet a Make.. no se donde acceder para pegar mi ID Client Y secret Client. Por favor

2 Likes

Normally you just need to togle the advance settings.

If ti is not working check with make.com there might be a bug


1 Like

Hi @Luis_Ortega

You can check the online help , where they have mentioned in detail on how to get the required IDs and how to set up the connection correctly.


Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

To connect your Google Sheet to Make (formerly Integromat), follow these steps to access the advanced settings for your Client ID and Client Secret:

1. Open Make Platform:

  • Go to Make and log into your account.

2. Create a New Scenario:

  • Once logged in, click on Create a new scenario. This will open the scenario editor where you can add and connect apps like Google Sheets.

3. Add Google Sheets Module:

  • Click on the + button to add a module.
  • Search for Google Sheets and select it.

4. Connect Google Account:

  • You’ll see an option to Add a connection to Google Sheets.
  • A window will pop up asking for permissions to access your Google account. If it doesn’t automatically ask for your Client ID and Client Secret, continue with the next step.

5. Set Up OAuth Authentication:

  • If Google Sheets asks for OAuth credentials (Client ID and Client Secret), here’s how to get them:

    • Go to Google Developer Console: https://console.developers.google.com/.
    • Create a new project (or select an existing one).
    • Enable the Google Sheets API: Go to Library > search for Google Sheets API > enable it.
    • Create OAuth credentials: Go to APIs & Services > Credentials > Create Credentials > OAuth 2.0 Client ID.
    • You’ll get your Client ID and Client Secret here.

6. Paste Client ID and Secret:

  • After generating your credentials, return to Make and paste the Client ID and Client Secret into the required fields in the connection window.
  • Authorize the connection by following the prompts.

7. Finish Setup:

  • Once connected, you should be able to choose a Google Sheet and define actions (like creating, updating, or reading data).

8. Test Connection:

  • To verify the setup, try running a simple operation like reading data from a Google Sheet.

That should be it! If you’re still having trouble, let me know!