Tag: google sheets

Load data into Google Spreadsheet from PHP

Lets say you have a PHP script that returns a value, based on a query string: Getting the result of that PHP script into Google Sheets is rather easy. Open Tools > Script Editor in Google Sheets and create a function like this: function getMyQueryValue(value) { var response = UrlFetchApp.fetch(“https://mysite.com.com/query.php?string=” + value); Logger.log(response.getContentText()); return JSON.parse(response); […]