Hi there,

i want to connect the Zoho Campaigns API to Google Sheets to pull contacts and so on in the sheet through Google App Script. I created a Client ID and a Client Secret and a GrantToken. But now i'm stuck because i have to use Self Client and therefore i dont have a redirect url. So how to proceed?

And a second question: Did i understand right that i have to create Access and refresh tokens every hour manually? How is this suppose to help to automate stuff?