python + Spreadsheet

google-app-engine, google-sheets, python

Solution

The easiest way to connect to Google Spreadsheet is by using this spreadsheet library. These 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)

Problem

Can anybody please tell me is there any possible way to connect to spreadsheet from python? I want to store some data from a form and submit it to google spreadsheet. Please help on this issue. What steps do I have to follow? Thanks in advance...

Original source