Using this script, I was able to create a start. I think that the things that I still wonder:
- Insert an image from URL
- Adjust the size of the text based on the length of the text in the spreadsheet
- Replacing/updating the current slides in the deck
This is at least a start.
via Alan Levine
Google Sheets is great for quickly spinning up dashboards and analysis, but getting raw data into Sheets from databases can be tedious.
In this post we cover a few ways to get data from your SQL database into Google Sheets.
Recently I had the opportunity to be interviewed with some of my fellow G Suite GDEs for a Google Apps Script marketing video that is being pulled together by Google. The final video is still in production and I look forward to seeing the results. Over the years I’ve either produced or appeared in a number of videos and the recording session for this video was definitely on a new level. Before the recording session I was given the questions I would be asked so that I could prepare some thoughts.
Apps Script Pulse is a new space to keep up-to-date with the latest contributions from the Google Apps Script community. Pulse is designed to compliment other community spaces – with the Apps Script Stack Overflow site supporting Q&A, the Apps Script Google Groupproviding a discussion space and the new G Suite Solutions Gallery providing a space for sample solutions – Apps Script Pulse is a distribution channel for community created content as well as surfacing highlights from existing spaces.
You can visit Apps Script Pulse and start browsing the content we’ve already collected and if you’d like to receive updates in your inbox you can subscribe to our daily digest of new posts. If you have content you would like featured in Apps Script Pulse you can ping us on Twitter @AppsScriptInfo or dropping us a line at firstname.lastname@example.org.
Apps Script samples for G Suite products. Contribute to gsuitedevs/apps-script-samples development by creating an account on GitHub.
Learn to do Automation with Apps Script in this premium, online video training course.
A free, introductory course teaching Google Apps Script from scratch
I have read a number of posts:
- Collins’ Beginner guide to APIs with Google Sheets & Google Apps Script
- Alice Keeler’s First Step – You Can Code Google Apps Script
- Jeff Everhart Add Custom Menus to Google Docs, Sheets & Forms
I look forward to this new offering. I always enjoy the way in which Collins’ breaks things down with his courses.
Totally Unscripted is a new Google Apps Script show organized by the community for the community. Each month members of the community will talk through some new developments in Google Apps Script as well as talking about a coding project or problem.