Google Sheets API returns “The caller does not have permission” when using server key

To solve this issue, try to: Create a service account: https://console.developers.google.com/iam-admin/serviceaccounts/ In options, create a key: this key is your usual client_secret.json – use it the same way Make the role owner for the service account (Member name = service account ID = service account email ex: thomasapp@appname-201813.iam.gserviceaccount.com Copy the email address of your service … Read more

What are the alternatives now that the Google web search API has been deprecated? [closed]

Yes, Google Custom Search has now replaced the old Search API, but you can still use Google Custom Search to search the entire web, although the steps are not obvious from the Custom Search setup. To create a Google Custom Search engine that searches the entire web: From the Google Custom Search homepage ( http://www.google.com/cse/ … Read more