python + Spreadsheet
Question: 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...


Answer: The easiest way to connect to Google Spreadsheet is by using this [spreadsheet
library](http://burnash.github.com/gspread). 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)
    

