Stack Overflow
Stack Overflow

Questions tagged [google-sheets-api]

The Google Sheets API lets developers write third-party applications that read and modify any aspect of spreadsheets. Not to be confused with [google-apps-script]

The Google Sheets REST API enables developers to create applications that read and modify the data in Google Sheets.

This API is useful for:

  • Managing the worksheets in a Google Sheets file
  • Consuming the rows of a worksheet
  • Managing cells in a worksheet by position
  • Performing complex formatting of cell text

Example quickstarts are available for most popular languages, along with Google-provided client libraries.

References

6071 questions
9
votes
4 answers

Google Sheets API v4 and valueInputOption

I have three columns in my spreadsheet. The first one is date, the second and the third are simple strings. When I do batch upload of my data valueInputOption = "RAW" I get a wrong result for my Date column. All dates have an invisible apostrophe…
yurart
  • 593
  • 1
  • 6
  • 23
9
votes
4 answers

How to insert row after the last row with value?

I am inserting data into a spreadsheet with the new Google Sheets API v4, the code works perfect and the data it is inserted well in the sheet. But how to find out the last row with data to add the data after this ? List> arrData =…
seba123neo
  • 4,688
  • 10
  • 35
  • 53
9
votes
4 answers

Write to GoogleSheet via API with Java

I am trying to write a value to a cell with Google Sheet API with Java. For reading I used guide from Java Quickstart which worked fine for me. For writing to Google Sheet I use: service.spreadsheets().values().update(spreadsheetId, "Sheet1!A4:H",…
Alex Kolo
  • 243
  • 3
  • 14
9
votes
1 answer

Why am I seeing "reference error: "Calendar" is not defined" when I run a Google Spreadsheet API script?

I made a working bound script in a clone of my original Google Spreadsheet, put together over a course of several days. I then copied my formula to a new spreadsheet. Suddenly, even though I don't think I made any changes to any relevant code, I'm…
Dr.Queso
  • 761
  • 2
  • 6
  • 11
9
votes
6 answers

Can we use Google Spreadsheet as a backend database

I am trying to develop an application, where I where fetching data from multiple clients related to some transactions. Now I want to make some analysis using the Google Spreadsheet. Is there any way by which I can achieve this using the ASP.Net…
Jagdeep Chawla
  • 91
  • 1
  • 1
  • 3
9
votes
5 answers

How to return instant response to JSONP request and continue processing after

I am using JSONP to collect data from the user but do not require the user to get a response. Therefore I want to send the user an instant response so they can continue without having to wait for the server processing. How do I send them a response…
Craig
  • 2,093
  • 3
  • 28
  • 43
9
votes
1 answer

Ajax calls made from Google Spreadsheet Custom Function

Has anyone ever tried to write a script inside a Google Spreadsheet to make an ajax call to a website? I want to make it so that the spreadsheet updates itself from the website. But after just putting this short block of code, I get thrown an…
user2577475
  • 161
  • 2
  • 2
  • 5
9
votes
4 answers

How can I get the number of rows in a Google Spreadsheet using api?

Is it possible to fetch the number of filled rows without fetching the whole spreadsheet, or find the first empty row number? I am using the python api wrapper if it matters.
canerbalci
  • 1,239
  • 1
  • 12
  • 16
8
votes
1 answer

Access Blocked: has not completed the Google verification process

I am building a simple script which polls some data and then updates a spreadsheet that I am giving to my client. (It is a small project and I don't need anything fancy.) So I created a Google Cloud project, enabled the Sheets API, and got a…
luqui
  • 59,485
  • 12
  • 145
  • 204
8
votes
2 answers

Writing to Google Docs Spreadsheet using PHP

Is there anyway I could write data to a Google Docs Spreadsheet using PHP, besides the Zend library? I have tried the Zend library, and while it is helpful, I want to be able to specify a specific row and column to write to, instead of writing to…
Abbas Zaidi
  • 85
  • 1
  • 1
  • 6
8
votes
1 answer

Unable to open Google xlsx spreadsheet / Also Google Drive permission Blocked

I have a Google Apps Script that I am currently using to successfully open a Google Sheets spreadsheet (read-only shared with my account) and perform some reading functions. I received another spreadsheet that I would like to run similar processes…
Royal2000H
  • 393
  • 2
  • 12
8
votes
4 answers

Client doesn't have sufficient permission

I am currently running library(googlesheets4) sheets_auth() dat=read_sheet("https://docs.google.com/spreadsheets/d/1R9XuH9Wej-p6HdkFGV2IsHuCmA9w0s7M3-jzE3S-Qrs/edit#gid=950673024", sheet="Summary", range=cell_rows(1:777)) and getting the…
Daniel Callow
  • 101
  • 1
  • 6
8
votes
1 answer

How to Print sheet/range using .gs script in Google Sheets?

I am trying to create a script in Google Sheets that select a range and print it. I am trying to print some information based on some parameters. I have the following script that sets the desired range, but I do not see a way to print it using…
relez
  • 750
  • 2
  • 13
  • 28
8
votes
1 answer

Google Sheets API appending extra apostrophe

I've been using this Google Sheets API code for a few months in Python to append data to a spreadsheet, but it recently broke. Can anyone see what is wrong with this? body = {'values': [['2019-9-1', '41']]} result =…
Elliott B
  • 980
  • 9
  • 32
8
votes
3 answers

curl: (3) [globbing] nested brace in column 189 when sending PUT request to Google Sheets API

I am trying to write to a Google Spreadsheet using Google Sheet API v4. The usage about the API is listed here I made a curl request that looks like the following curl -v\ -H 'Authorization: Bearer…
daydreamer
  • 87,243
  • 191
  • 450
  • 722
1 2 3
…
99 100