[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)