What is the best method for Google API Authentication

Hi @Connor1868 

Try using this Zap action: GSheets - API Request

I want to call the API request within Zapier Code so I can use it inside a for loop.

I need to iterate through this JSON object, checking if the email exists in a master sheet, if not add the contact to the sheet and add the contact to SendGrid. Then once the contact has been sent a email, delete the contact from SendGrid

Contacts JSON Objects:

[
  {"first_name": "John", "last_name": "Doe", "email": "john.doe@example.com", "customField": {"reservation_date": "2024-03-28T21:30:00.000Z"}},
  {"first_name": "Jane", "last_name": "Smith", "email": "jane.smith@example.com", "customField": {"reservation_date": "2024-03-28T18:30:00.000Z"}},
  {"first_name": "Alice", "last_name": "Brown", "email": "alice.brown@example.com", "customField": {"reservation_date": "2024-03-28T20:30:00.000Z"}},
  {"first_name": "Bob", "last_name": "Johnson", "email": "bob.johnson@example.com", "customField": {"reservation_date": "2024-03-28T20:30:00.000Z"}},
  {"first_name": "Emily", "last_name": "Taylor", "email": "emily.taylor@example.com", "customField": {"reservation_date": "2024-03-28T18:30:00.000Z"}},
  {"first_name": "Michael", "last_name": "Williams", "email": "michael.williams@example.com", "customField": {"reservation_date": "2024-03-28T18:00:00.000Z"}}
]

Basically I want to store contacts that I’ve sent emails to in a Sheet vs storing them in Sendgrid since I only send them one email.

@Connor1868 

Why not use the Zap action GSheets - API Request, then pass the data into a Code step?

Hi @Connor1868! 👋

Just wanted to check in to see how you’re getting on. Did you have any luck with Troy’s suggestion of passing the output from a API Request action to a Code step?

Keen to ensure you’re all set so please let us know whether you’re still stuck at all!  

Hi @SamB and @Troy Tessalone 

Thanks for the response. The Sheets API request action isn’t going to work because I need to make the API request inside of a Zapier Code block so that I can use the raw response.

How would you authenticate a Google API request within a Zapier Code block?

Thanks!

@Connor1868 

Using the GSheets API Request Zap action it returns the RAW JSON as a data point that you can use in a Zap Code step.