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
1
vote
1 answer

Can't read data simultaneously from the first three columns of a google sheet

I'm trying to read data from the first three columns of a google sheet using gspread. The three columns that I'm interested in are ID,NAME and SYMBOL. The name of the sheet is testFile. If I try like the following, I can get data from the first…
MITHU
  • 113
  • 3
  • 12
  • 41
1
vote
1 answer

Is there a way to unmerge Google Sheets cells with gspread or some other Python library?

gspread has this method for merging cells but I don't find anything for unmerging. I see there's a way to do this in JavaScript, though, but my project is in Python so I would really like to stick to it.
m_ocean
  • 327
  • 3
  • 11
1
vote
1 answer

Trouble implementing batch update rows while writing to a google sheet using gspread

I'm trying to do batch update rows while writing data to a google spreadsheet using gspread library. When the following function get_content() produces a single result, I can do batch update rows flawlessly: import gspread import requests from…
MITHU
  • 113
  • 3
  • 12
  • 41
1
vote
0 answers

How to create a Scatter Plot in google sheets API in Python

I'm having problems creating a scatter plot in Google sheet API in Python. I've already been able to create the new sheet but with NO DATA. Also, I'm not sure I am adding the necessary number of variables for the scatter plot. I've ran a test on…
Hernan Trujillo
  • 11
  • 1
1
vote
1 answer

range response have difference with range request when last range have empty value

i try get data from google sheet using method spreadsheets.values.get. sheet tabel 1 A B C 2 One Two Three 3 One Two 4 One Two Three the problem is when making a request like : 'range' => 'A2:C', return value data on range 3 only…
Syaifudin Zuhri
  • 108
  • 1
  • 2
  • 11
1
vote
2 answers

Google Sheets API v.4 for PHP: exclude certain columns from $request

In this Google Sheet using the Sheets API, what's a simple example of excluding columns B and C from either retrieval from the Sheet during the request, or display via PHP? Can columns B and C be excluded from the $service request? Or, can columns B…
BlueDogRanch
  • 721
  • 1
  • 16
  • 43
1
vote
0 answers

How to get ACCESS TOKEN of Google Sheet API in react native

I am developing an app in react native, where user need to read/write data to google spread sheet. I am seeing alot of tutorial which was used for javascript/nodejs application, which I cannot apply in my project as it is not compatible with React…
Alauddin Ahmed
  • 1,128
  • 2
  • 14
  • 34
1
vote
1 answer

Macro Google Sheet "Macro action change"

I would need a change in how this macro works function getDynamicRow(){ var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('B.Wioski'); var sourceRange = sheet.getRange('A1:F26500'); var data =…
P G
  • 21
  • 5
1
vote
1 answer

Data Missing automatically from Google Sheets

I have written some scripts in google app script to move that specific row on the basis of particular value of a cell. But surprisingly some row are missing automatically. These rows are vanished & found no where in sheet. Please help to find why…
Ankur
  • 11
  • 1
1
vote
1 answer

Invalid JSON payload received when appending to Google Sheets API V4

Hi I've a small tool to edit a Google Sheet using the API v4. I can read the data from said sheet but I can't append anything. $.ajax({ url: 'https://sheets.googleapis.com/v4/spreadsheets/' + …
Guillermo Oramas R.
  • 1,303
  • 2
  • 14
  • 31
1
vote
0 answers

Duplicates developer metadata when using cut + paste

I create Developer Metadata for each of the columns in the sheet. If a new column gets created, I track it and create another developer metadata for it. The process above works great until the user starts to move columns using Cut (cmd+x) and Paste…
Aviv Kebab
  • 21
  • 3
1
vote
1 answer

URL Extractor in Google Scripts getting TypeError

I'm trying to create a script that will extract hidden hyperlinks from the first column of a google sheet and place just the link in the column to the right. This si the code I have so far: function getURL() { var sheet =…
stibb
  • 11
  • 1
1
vote
1 answer

load a csv file into google sheet using python

This would seem like a simple task but it's been eluding me for weeks. It's pretty simple. I have a CSV file on my local drive. I want to append the rows into an existing Google Sheet (already has rows which I need to keep) Here's the code: import…
SRev
  • 39
  • 7
1
vote
1 answer

how to solve "'Resource' object has no attribute 'service' " in python , google api

i was trying to make a project using google api. in that project i give a string and the python script is supposed to change/modify that a cell in google sheet and change the value of the cell that string. But the problem is that there is a…
Scarlett
  • 25
  • 3
1
vote
1 answer

How to get google sheets name

Given a url of googlesheets like https://docs.google.com/spreadsheets/d/1dprQgvpy-qHNU5eHDoOUf9qXi6EqwBbsYPKHB_3c/edit#gid=1139845333 How could I use gspread api to get the name of the sheet? I mean the name may be sheet1, sheet2, etc Thanks!
jason
  • 7
  • 5
1 2 3
…
99 100