So I was able to fix an error I had, but now I am getting an error for the field entered through the setFields method. I thought you could put any string, but it seems that it’s not the case at all. The documentation doesn’t seem to provide what might be the issue. I get the error: https://develop…
Tag: google-sheets
Add array form data in google sheets api through PHP
I am using google sheets API in PHP to add my html form data in google spreadsheet. All other data have been appended in the respective cell of the sheet since each value had single data except one data which is in array since the html input data is in multiple checkbox. My google sheet form: And my code in
Convert Local Excel.xlsx File to Google spreadsheet Google DRIVE API
I am trying to convert a local Excel.xlsx file with all existent design, format and formulas existent in my local Excel file. How can I do that using Google API with PHP? What I was doing but not working was : But that is not working. How should I correct? Answer I believe your goal as follows. You want to
Google Sheets v4 Update Effect JSON Endpoint Data? Shut down on June 8, 2021
I read this article about a Google Sheet API v4 update. Do I need to change the current code structure? I am using simple JSON data for displaying Google sheet data on the web. I made some PHP and …
Get Cell Format from Google Sheet API
I’d like to retrieve the format/type of the cell that set in google sheet, for example Plain text, Number, Date, Time and etc from the Google Sheet API. Google Sheet format screenshot here. Google Sheet Sample I’m using the API from this Srijan’s reference, it only able to pull out the value…
PHP – read CSV from Google Sheets but sheets redirect to login
I have created several sheets in Google Sheets that I’m retrieving with a CSV output through PHP. It was all working fine until today while I have not changed anything to my code. I was using this: It was working fine. If I try to access my sheet directly through the browser I get a CSV file in return b…
Duplicate whole spreadsheed using Google Sheets API
I have a spreadsheet with prepared template and a bunch of Apps Script code to work with sheets. I need to export data into this template using Google Sheets API, but doing it in the same spreadsheet for all users is not the best idea. Therefore, I need to create a new spreadsheet for each user. I managed to …
Google Sheets API Insert Row at a Row Position
I am using the Google API to add rows to a Google Sheet. This is all working well, but the new rows are being added to the end (using the append method). I would like to insert the row at the top, …
Search a google spread sheet using JQuery
I want to search a specific column in my google spreadsheet which contains strings. I used PHP to read the data from the sheet and stored them into an array. Printing the array shows me the column values, however when using (json_encode), I am only getting the last value in the array which is pretty weird. He…