In a form which takes input and updates the value in a spreadsheet. It was working fine before but suddenly stopped working with this error message: According to other questions and answers it is because of authentication problem, but the form was working for 5 years with the same authentication so it is conf…
Tag: google-sheets-api
“Invalid requests[0].updateCells: Invalid field” when using barchUpdate on googlespreadsheet API
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…
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…
Changing Cell Colour With Google Sheets API (PHP)
I’m trying to change a ranges colour via the Google Sheets API in PHP. I have done around an hour of researchig. The code below is as far as I’ve got. If I take out this: Then the code works to update the sheets title. However, I can’t seem to update a ranges colour. Any advice would be grea…
Google sheets API range issue
I have a google sheet like this. Those values are just place holders at the moment for my headers When I run my PHP script with $range = ‘Sheet!F2:L2’; to insert records into the google sheet via API/service account and I only want to start inserting at ROW F for all attempts, it inserts fine on t…
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, …