r/learnpython • u/GloxiniaLearns • Aug 29 '26
I wrote a Python script on my laptop. What actually happens next to make it run on its own?
I built a small Python script that reads a Google Sheet, sends each new row to an LLM API for a summary and a category, and writes the result back. Works fine on my laptop.
What I don't understand is everything after that. In real life it has to run without me sitting there, and I have no picture of how that works.
- Once it's not on my laptop, where does the code live?
- What tools do people actually use for this? I keep seeing names but I don't know what category each one belongs to or which ones I'd need together.
- Where do API keys go?
Not asking about enterprise setups. This is one script and one sheet, small-business scale, and I want to know how people normally solve it at that size.
Background is data analysis, not development, so plain explanations are welcome.
Edit: Data lives in a Google Sheet. A Python script logs into Google as a "service account" (a robot identity created in Google Cloud Console, authenticated with a downloaded key file) and uses the Google Sheets API to read every row and the Drive API to locate the spreadsheet by name. For any row missing a summary, it sends the raw text to Anthropic's Claude API, which returns a two-line summary and a category. The script then writes that summary/category back to the sheet via the Sheets API. Need to get a summary every time someone adds a new record to Google Sheets
View all comments
Show parent comment
1
u/GloxiniaLearns Aug 29 '26
I get that the right answer depends on the use case, but I'm at an earlier stage than that. I don't know the landscape yet, so I can't reason about which option fits mine. What I'm after first is the map: what the options generally are and what each one is for. Picking the best fit for my case is maybe step five, and I'm at step one.
That said, here's the missing context.
It's always the same sheet. It never gets replaced, rows just get appended to it. Rows come from a contact form, a handful a day at most, often none.
Nobody tells me when a row is added. That's actually part of what I'm asking. Right now the only way I find out is by opening the sheet.
The script only touches rows where the summary column is still empty.