Tag: Apps Script

Replied to Mass Producing Google Slides from Sheets: Scripts Are Your Friends (CogDogBlog)

To me, buying an app is serving me a fish dinner; giving me a script I can modify is a lesson in fishing. I’d rather fish. You?

Thank you so much for sharing Alan. I really like the starting point Rohe provides. I too would rather fish, than processed fish fingers.
Replied to How to Inject Data from Google Sheets Into a Google Slides Presentation | UpBuild (UpBuild)

Stop copying and pasting data from Google Sheets. Have it automatically injected into a Google Slides presentation with this Apps Script.

I always wondered about the possibility of automating the process of populating Slides using text from Sheets to create visual quotes, however I never quite ended up down that rabbit hole.

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

Bookmarked How To Connect Google Sheets To A Database, Using Apps Script – Ben Collins (Ben Collins)

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.

I usually drag in data from my blog via RSS, however I wonder if this might be a cleaner method.
Replied to Gmail Mail Merge For A Specific Label With Apps Script – Ben Collins (Ben Collins)

Every Monday I send out a Google Sheets tip email and occasionally I’ll include a formula challenge. I posted Formula Challenge #3 — to alphabetize a string of words separated by commas using a single formula — in January 2020 and had over 150 replies! It would have been too time consuming to reply to … Continue reading Gmail Mail Merge For A Specific Label With Apps Script

Ben, I really need to find some time to dig into these ideas for automation and your work on Apps Script. Along with Martin Hawksey’s post on sending personalised images, they offer some great ideas for improving workflows.
Liked

Liked My personal how/why/what of Google Apps Script (MASHe)

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.

Bookmarked AppsScriptPulse – The latest from the Google Apps Script community (AppsScriptPulse)

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 pulse@appsscript.info.

Martin Hawksey has created a site to collate different App Script projects.
RSVPed Interested in Attending Apps Script Blastoff!

A free, introductory course teaching Google Apps Script from scratch

I have long had an interest in Google Apps Scripts. However, I have really gotten past simply appropriating other people’s code, especially Martin Hawksey’s work.

I have read a number of posts:

I look forward to this new offering. I always enjoy the way in which Collins’ breaks things down with his courses.

Bookmarked Totally Unscripted (YouTube)

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.

Totally missed this and only just came upon it via Ben Collins’ newsletter.