IFTTT has made some updates to its Google Docs and Google Drive service. “Historically, Applets that interact with Google Sheets or Google Docs have fallen under the umbrella of Google Drive. Today, we’re excited to introduce new, separate services for Google Sheets and Google Docs — and some big improvements to the original Google Drive service.”
Google Blog: Pivot to the cloud: intelligent features in Google Sheets help businesses uncover insights. “We launched ‘Explore’ in Sheets to help you decipher your data easily using the power of machine intelligence, and since then we’ve added even more ways for you to intelligently visualize and share your company data. Today, we’re announcing additional features to Google Sheets to help businesses make better use of their data, from pivot tables and formula suggestions powered by machine intelligence, to even more flexible ways to help you analyze your data.”
Make Tech Easier: 10 Google Sheets Add-ons You Should Consider Using . “Google Sheets add-ons go beyond rows and columns. You can use extensions to express mathematical formulas in graphs, build apps, develop APIs, craw up coordinates on maps, build machine learning tools for predictive analysis, and much more. Below are some of the best Google Sheets add-ons to help you be more productive in your work.” Dang it, I want the time to try most of not all of these.
Amit Agarwal keeps cranking out excellent tools. the latest from Digital Inspiration: How to Create Personalized Documents from a Google Spreadsheet in Minutes. “Introducing Document Studio, a powerful Google add-on that lets you effortlessly generate documents and reports using merge data stored inside Google Sheets. It can also create documents with live data from Google Forms submissions. The generated documents can be automatically sent inside personalized email messages using built-in Mail Merge.” This isn’t free, but the personal version is $29 a year.
From a new company, Coda: It’s a new day for docs.. “Why are we still clinging to metaphors long-forgotten: the accountant’s grid, the typist’s paper, the professor’s slides? Why do these tools insist on creating boundaries where we don’t need them — forcing us to choose between a document or a spreadsheet? How do we empower the growing class of people who stretch docs and turn them into ingenious tools? Finally, what would we build if we started from scratch?… Coda is a new type of doc that blends the flexibility of documents, the power of spreadsheets, and the utility of applications into a single new canvas. That’s Coda. It lets you make a doc as powerful as an app.” I signed up to be considered for the beta in about one tenth of a second.
Spotted by Esther S. on a Reddit Thread: a database of LGBTQ characters in Fantasy fiction. From the Reddit thread: “For the Mark I, I am only accepting purchasable novels. No web serials, no short stories, no poetry, no songs, no anthologies (unless it is all one world/series. Think Side Jobs by Jim Butcher or Spirit Caller by moi). For the Mark I, do not enter subgenres. If you aren’t 100% sure about the overall genre, feel free to ask below or enter the question into your form (more on that below). My hope is to have the Mark I database ready for linking into the Find Books list by the end of the month. The form will still exist for future entries, and I’ll do another update thread in a few months time if there is a need (and maybe do things like anthologies, subgenres, etc).” At this writing, there are over 250 entries.
Google Blog: Analyze your business data with Explore in Google Sheets, use BigQuery too. “A few months back, we announced a new way for you to analyze data in Google Sheets using machine learning. Instead of relying on lengthy formulas to crunch your numbers, now you can use Explore in Sheets to ask questions and quickly gather insights. Check it out.”