Stack Overflow
Stack Overflow

Questions tagged [gspread]

gspread is an asynchronous Python library for interacting with Google Spreadsheets.

gspread is a Python library for interacting with Google Spreadsheets.

949 questions
0
votes
1 answer

Appending data on to a Google Spread-Sheet with gspread

Problem: I am trying to append data on to a Google spreadsheet. I cannot seem to append the data on to the following line. For example if the spread sheet has x rows on column A (so the last cell that has data is A x ), I would like to add the next…
3kstc
  • 1,871
  • 3
  • 29
  • 53
0
votes
1 answer

Python gspread: equivalent of getLastRow()

I currently use this code which I think takes longer the more the sheet grows: def findLastRow(): global spreadsheet global datastartrow print 'rows: ', worksheet.row_count lastrow = datastartrow while(True): val =…
ebswift
  • 11
  • 3
0
votes
1 answer

Download Google Sheet as CSV and keep numbers values as text

When I download one of my Google Sheets to csv, it removes the proceeding "0" from my values. For example, "0666666" will become "666666". How can I modify the code below so that it keeps that front zeros? Thanks! def static_tabs(): static_tabs…
Andy Do
  • 99
  • 1
  • 2
  • 14
0
votes
1 answer

Gspread - Move column down as soon as new row is inserted

I have a little script that gets data out of an API and writes it to a google spreadsheet. This works with gspread. I want the script to run every night to check for new updates. Currently it looks like this Event date - Event Location - Performer -…
Martijn Kerckhaert
  • 494
  • 1
  • 6
  • 21
0
votes
0 answers

Start oauth2-gsread

I have problem with use gspread and oauth2. I want to write some information in spreadsheets google. import json import gspread from oauth2client.client import SignedJwtAssertionCredentials json_key =…
Ivan219
  • 1
  • 1
0
votes
1 answer

gspread spreadsheet not loading, no errors

I am writing a python script using gspread. Here is the code: json_key = json.load(open('')) scope = ['https://spreadsheets.google.com/feeds'] credentials = SignedJwtAssertionCredentials(json_key['client_email'],…
rishubk
  • 441
  • 2
  • 8
  • 19
0
votes
1 answer

Issues with adding a variable to python gspread

I have started to use the gspread library and have sheet already that I'd like to append after the last row that has data in it. I'll retrieve the values between A1 and maxrows to loop through them and check if they are empty. However, I am unable…
xeet
  • 163
  • 2
  • 10
0
votes
1 answer

Get a comma separated cell value list using gspread

I want to send mails with the email addresses stocked in a google spreadsheet. I am able to get the cell value but I get : (,) (,) ... In order to use MIMEMultipart, I need a comma…
Thibault Bouveur
  • 13
  • 7
0
votes
1 answer

Using Python to write to Google Sheets

I want to take data from a a website using Python, and write it onto the Google Sheets that I own. I searched for a way to do this for like an hour, but can't really find it. I found gdata and gpsread but they both look like they're outdated unless…
rishubk
  • 441
  • 2
  • 8
  • 19
0
votes
1 answer

Can I control the output of insert_row in GSpread?

I have successfully imported some data into Gsheets using Gspread(https://github.com/burnash/gspread). However, I see insert_row is getting both the values and the cell details. Can I control it, I want only 'value' to be imported not the cell…
user4398985
0
votes
2 answers

Python - problems accessing a Google spreadsheet using an OAuth 2.0 service client

I own a Google spreadsheet which I am trying to access via a little OAuth 2.0 Python service client I am writing, using gspread and oauth2client. I've created an OAuth 2.0 service account on Google Developers Console and have shared the spreadsheet…
user997225
0
votes
1 answer

Google Spreadsheet Secure Client Email Sharing?

I am currently using Gspread python library to write data to a google spreadsheet. However, the google spreadsheet is secure and I am unable to share the client email to write data to the spreadsheet. Is there a work around to write data from my…
Tech Tech
  • 11
0
votes
1 answer

Unable to authenticate using gspread to access Google Drive

I use python to generate a way to follow up with prospects who I have sent books to but haven't heard back from. Quick way to catch up with them. Must stress this isn't used for SPAM. I have one file gmail_variable.py which contains GMAIL_USERNAME =…
PatGW
  • 369
  • 6
  • 19
0
votes
2 answers

How to link google account when using gspread and python?

I am trying to use gpread with python to edit google spreadsheets. I followed this tutorial: http://gspread.readthedocs.org/en/latest/oauth2.html When I run my code, it says that there is no module named oauth2client.client. Do I need to install…
UltraSaucy
  • 11
  • 1
  • 2
0
votes
1 answer

How to get python gspread to use a SOCKS proxy server for connections?

How could I get my script that's using gspread to have the gspread connections to google's servers use a SOCKS proxy?
GJ.
  • 5,226
  • 13
  • 59
  • 82
1 2 3
…
63 64