Skip to main content

Does anyone know if it’s possible to connect to Google Sheet REST API in Code by Zapier (Python)?  I’m having issues with oauth authentication...

Hi @Google Forms -> Monday.com 

Good question.

Why not use this Zap action: GSheets - API Request

This will handle the GSheets authentication for you.

 


I can do that, but I need to loop through multiple rows on a google sheet, and I am burning up many steps in zapier...


@Google Forms -> Monday.com 

Unsure what you are trying to do specifically within in the Code step, but some GSheet action support line items.

 

So in theory you could use these actions steps:

  • Action: GSheets - API Request
  • Action: Code
  • Action: GSheets - Update Row(s)