Python Forum
Jump to next empty column with Google Sheets & Python - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Web Scraping & Web Development (https://python-forum.io/forum-13.html)
+--- Thread: Jump to next empty column with Google Sheets & Python (/thread-19143.html)



Jump to next empty column with Google Sheets & Python - Biks - Jun-14-2019

I have a series of python scripts that enter data into a Google sheets column. I want to jump over to the next empty column if I run everything the next day. Here's a simple version of what I've got - it just puts today's date into cell A1.

import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
creds = ServiceAccountCredentials.from_json_keyfile_name('client_penny.json', scope)
client = gspread.authorize(creds)

from datetime import datetime

date = datetime.today().strftime('%Y-%m-%d')

penny = client.open('pennystocks').worksheet('DGTW')

penny.update_acell('A1', date)
I want the date to go into B1 if I run it tomorrow (or whatever the next available column is if I've already run it a few times).

I found these related examples, but I think they're for javascript. (I'm a noon at this)

https://webapps.stackexchange.com/questions/101197/script-to-have-google-sheets-jump-to-the-next-available-row-in-column-a-automati/101200

https://webapps.stackexchange.com/questions/121612/jump-to-next-empty-cell-in-specific-column


RE: Jump to next empty column with Google Sheets & Python - aguiatoma - Jun-16-2020

Hey there, I am currently having the same question, I need to update a google sheet every hour with 2 new columns of data but I need it to jump to next empty column to begin wrtitng the data.

Did you find a solution to this could you share it with me in case you have one?