I'm using Python and Google Sheets to manage my wedding invitation list. Lob for cards, google contacts for contact data, gsheets is the main db. It works well.
Google Spreadsheets and Python
61–70 of 143 posts
Re: Google Spreadsheets and Python
#62I never published it, but I actually wrote a service that uses google sheets to manage SSH access on your servers. Users simply submit a google form with their SSH key, and it's automatically pulled by a daemon on each host. It comes complete with admin/sudo access toggling.
Re: Google Spreadsheets and Python
#63A friend who works at the Dallas Animal Shelter (a non-profit) asked me to help automate their process of generating reports from data gathered via Google Forms, which they were doing by hand every month... As a developer who is used to high technical investment into complex systems, I had to take a completely different approach to storing their information. Google Forms + Spreadsheet + Python works perfectly for use…
Really curious in the "low" technical investment answer: where/how does the Python end of this system get run?
>which they were doing by hand every month
I would assume they just installed python on whatever machine they were originally using to hand-generate reports and the job of that person now is to just run the python script and wait for it to finish.
Re: Google Spreadsheets and Python
#64Earlier quoted context omitted.
(author here) Main advantage in our usecase is getting the CUD interface for free.
For free ? Where would the python code run ?
He said just the CUD part (Create Update Delete). The assumption is that your data can be entered manually through the Sheets UI and your code only needs to do the Read part.
Re: Google Spreadsheets and Python
#65I went pretty far down the path of trying to build applications with Google Spreadsheets and Apps Scripts (we still have some major business processes running on it). It's definitely made me feel the need for something between Spreadsheets and custom development or Salesforce - something like what I imagine MS Access solved in the earlier days.
Here's what it'd need:
- Spreadsheet like UI - Validations and field data types (major liability of spreadsheets) - Good forms integration - Custom code like Apps Script capability - Something around workflow and business logic
I think Airtable gets pretty close but I haven't been willing to switch cause of some limitations but I do like where they're going. I'm considering pulling the trigger for Salesforce but keep hearing that it's really easy to shoot yourself in the foot.
Re: Google Spreadsheets and Python
#66I used Google Sheets as the DB backend for a membership management site for my local neighbourhood organization. So far it has worked great (for few users, but that was part of the spec).
Here's the project, and there's more rationale/investigation in the README: https://github.com/adam-p/danforth-east
(And... it looks like I need to update from Sheets API v3 to v4.)
Re: Google Spreadsheets and Python
#67I love Google Sheets. It is so much more powerful than 99.9% of the users appreciate. Here is how I use it at my day job as head of PM at New Relic: - Fetch deals closed and lost hourly from Salesforce - Fetch for each of our 14k+ paid accounts usage metrics using our Insights product - Pull both items into a nice color-coded business dashboard that is near realtime - Send said dashboard out as a PDF to a bunch of st…
Ever since I learned R and Python, I have dumped Excel. All my heavy lifting is done in a proper programming language, and for all the spreadsheet things that I need, Google Sheets is perfect. There's also something pretty magical about the sharing functionality when two people work on a document at the same time. Not to mention that all my sheets are a browser shortcut away, anywhere.
For a free software spreadsheet people can work on at the same time, there's EtherCalc: https://ethercalc.net/
Re: Google Spreadsheets and Python
#68[deleted]
Re: Google Spreadsheets and Python
#69I would love if I could use Ruby in Excel to program styling and transform cells, I wonder why I haven't seen anything like that.
Re: Google Spreadsheets and Python
#70I love Google Sheets. It is so much more powerful than 99.9% of the users appreciate. Here is how I use it at my day job as head of PM at New Relic: - Fetch deals closed and lost hourly from Salesforce - Fetch for each of our 14k+ paid accounts usage metrics using our Insights product - Pull both items into a nice color-coded business dashboard that is near realtime - Send said dashboard out as a PDF to a bunch of st…
This Blogger has lot of Google App Script that might be helpful for anyone interested in Google App Script - https://digitalinspiration.com/google-addons