401 Unauthenticated Error – Zoho CRM to Google Sheets Integration

401 Unauthenticated Error – Zoho CRM to Google Sheets Integration

Hi

I'm building an Automation Function in Zoho CRM using Deluge that appends contact data from Zoho CRM into a Google Sheet whenever a new contact is created.

WHAT I'VE DONE:

I created a connection in Zoho CRM (Developer Hub → Connections) with the following details: - Service: Google Sheet

Scopes: https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/drive -  I'm using this connection inside an invokeUrl call in my Automation Function to make a POST request to the Google Sheets API v4 append endpoint.

THE PROBLEM: The API call is returning a 401 UNAUTHENTICATED error with the reason "CREDENTIALS_MISSING". This means the OAuth token from the connection is not being attached to the request at all, even though the connection shows as "Connected".