[HN Gopher] Sheetfu - Python library to interact with Google She...
       ___________________________________________________________________
        
       Sheetfu - Python library to interact with Google Sheets V4 API
        
       Author : jeanloolz
       Score  : 141 points
       Date   : 2020-01-01 15:22 UTC (7 hours ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | 6gvONxR4sf7o wrote:
       | Anyone tried airtable? It seems like it's designed specifically
       | for this, and looks nice, but the fact that they limit number of
       | rows per table on the free plan is a bit of a WTF.
        
         | wy35 wrote:
         | I think we can cut Airtable a little slack since it's geared
         | towards professionals/businesses instead of average consumers.
         | Kind of like how Slack puts a cap on the number of messages in
         | their free version.
        
         | ShakataGaNai wrote:
         | I've tinkered with Airtable a bit and it's a solid product.
         | It's a "database" shown in the style of a spreadsheet. With a
         | number of great features, but of course you got to pay for
         | that.
         | 
         | The plan limit for free I get. However overall I think they use
         | the records-per-base limit as their major "please don't use us
         | for anything automated" function. You couldn't, say, build a
         | light CRM on anything less than the enterprise version because
         | 50k records (for pro aka $20/user/mo) just wouldn't cut it.
         | 
         | For those people who need database type powers for a very very
         | small company - it's really impressive. Anyone
         | larger...probably builds something themselves.
        
           | wy35 wrote:
           | I also messed around with Airtable a bit and I do agree that
           | it's a very polished experience. Interestingly, I've noticed
           | that there's actually a large amount of real estate agents
           | who are sick of Salesforce and are very hyped for Airtable.
           | They're waiting for Airtable to add some essential features
           | Salesforce has before jumping ship.
        
             | jamessun wrote:
             | What are some of the features missing in Airtable that you
             | think would make it more palatable for real estate agents
             | to use?
        
       | cgidriver wrote:
       | is there something like this for gmail? Where I could query
       | emails from Python and act on them?
        
         | xtreak29 wrote:
         | This might help :
         | https://automatetheboringstuff.com/2e/chapter18/
        
         | slightwinder wrote:
         | GMail has an IMAP-interface. You can use any imap-capable
         | solution, including pythons own imaplib.
        
           | bonzini wrote:
           | IMAP cannot operate on a whole thread at a time. Ironically
           | you will hardly notice the difference when operating with the
           | web interface, which is very much thread based, but it can be
           | useful to apply a label to a whole thread if your interaction
           | with GMail happens in Thunderbird or mutt. For example, I
           | have a Google Apps script that adds a label to a whole thread
           | whenever someone CCs me on a bug, so that the entire bug
           | suddenly pops up in the "my bugs" Thunderbird folder,
           | including messages prior to my being added.
        
       | mushufasa wrote:
       | also see stencila https://stenci.la
        
         | agravier wrote:
         | Looks like nice stuff but this is not yet something that can be
         | used if one is not part of the closed beta.
        
       | master_yoda_1 wrote:
       | Why it is trending at no 1? I think I need to stop reading hacker
       | news :(
        
         | packetslave wrote:
         | Go right ahead
        
       | ma2rten wrote:
       | Is it possible using this or pygsheets to open a sheet that is
       | editable by link without authorizing your account?
        
         | ShakataGaNai wrote:
         | No. The API's require authentication to function.
        
       | jonas_b wrote:
       | Seems like re-creating pygsheets, no?
       | https://github.com/nithinmurali/pygsheets
        
         | jeanloolz wrote:
         | Author here: Sheetfu original goal was to port the Google Apps
         | Script API for spreadsheet (made in javascript) to Python, so
         | you'll see a lot of common ground between those 2 libs.
         | 
         | You could probably achieve the same with both Pygsheet and
         | Sheetfu, the interface is a bit different. Sheetfu, however,
         | contains the Table module, which completely abstracts the
         | coordinate system for a more ORM-ish syntax.
        
         | washadjeffmad wrote:
         | Similar in function, different in application? They don't need
         | to call it yapygsheets for it to be their own.
        
       ___________________________________________________________________
       (page generated 2020-01-01 23:00 UTC)