All geek questions in one place

Python + Spreadsheet

Can someone tell me if there is a way to connect to a spreadsheet from python? I want to save some data from the form and send it to google spreadsheet. Please help on this issue. What steps should I follow?

Thanks in advance...

+3
source share
5 answers

The easiest way to connect to Google Spreadsheet is to use this spreadsheet library . Here are the steps you need to follow:

import gspread

# Login with your Google account
gc = gspread.login('account@gmail.com','password')

# Spreadsheets can be opened by their title in Google Docs
spreadsheet = gc.open("_YOUR_TARGET_SPREADSHEET_")

# Select worksheet by index
worksheet = spreadsheet.get_worksheet(0)

# Update cell with your form value
worksheet.update_cell(1, 2, form_value_1)
+9
source

, OAuth, API- gdata Python - . , OAuth Python App Engine.

+1

API Google Spreasheets, :

http://github.com/yoavaviram/python-google-spreadsheet

App Engine.

+1

Source: https://habr.com/ru/post/1712852/

More articles:


All Articles