First let me say I do not know much code, but am trying to get data using API from GoCanvas into a Google sheet. I set my trigger to execute every hour, then I connected to GoCanvas and am able to see my data. BUT, I can’t seem to figure out how to get it to go into a Google Sheet. I did all the tutorials, but I can’t seem to make it work. Help?
If possible, I would also like to pull only specific pieces of data from GoCanvas into the Google sheet, but since I can’t get it to the Google sheet, I can’t do that either. Any help would be appreciated.