AppsScriptPulse

Solutions, Sheets

Automating Mailchimp Campaigns using Google Apps Script — PART I

Tags:
| | 0 Comments |

Mailchimp has an amazing, well documented RESTful API. I loved exploring all what it had to offer and using it with Google Sheets and automating the whole campaign process right at the click of the button was surely fun.

Some detailed guidance on composing marketing campaigns in Mailchimp using Google Apps Script.

Source: Automating Mailchimp Campaigns using Google Apps Script — PART I

Solutions, Sheets

BigQuery create partitioned table and load CSV with Apps Script

Tags:
| | 0 Comments |

Work with partitioned table and upload a csv file in BigQuery with Apps Script.

BigQuery is the famous Google database to store huge amount of data and query them fastly. For a recent a project I had to use it for storing some logs so here the code used with Google Apps Script to create the table and load a csv file from Google Drive.

Source: BigQuery create partitioned table and load CSV with Apps Script

Solutions, Gmail, Sheets, Slides

Send bullk emails with personalised images in G Suite using Google Apps Script

Tags:
| | 0 Comments |

Earlier in the year I managed to get a bulk emailing script published in the G Suite Developer Solutions Gallery. In this post I want to show you how you can extend this script so that you can send personalised images using Gmail, Sheets and Slides.

Source: Send bullk emails with personalised images in G Suite using Google Apps Script

Solutions, Sheets

Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets – Yagisanatode

Tags:
| | 0 Comments |

This course requires a rudimentary understanding of very basic Javascript concepts and of what an array is. Nevertheless, if you want to come in blind you should be able to pick things up with a bit of Googling.

One of the major regular tasks that Google Apps Scripts can do for Google Sheets is to automate the transformation of data from one state to another.

Sometimes this task can simply be accomplished by building dynamic templates using the vast functionality of Google Sheets. Other times automation via Google Apps Script is a better tool for the job.

Source: Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets – Yagisanatode

Solutions, Sheets

Retrieving volunteer records by SQL with Google Apps Script in Google Spreadsheet

Tags:
| | 0 Comments |

Recently, I am working for an NGO supporting those severe handicapped. This article documents how I retrieve target entries programmatically.

Source: Retrieving volunteer records by SQL with Google Apps Script in Google Spreadsheet

Solutions, Sheets

Analyze sentiment of open-ended feedback and gain insights in Google Sheets Sheets to Apps – YouTube

Tags:
| | 0 Comments |

Some of the most valuable insights come from free-form user feedback, but text data can be difficult to process and summarize in a scalable way. In this episode of Sheets to Apps, Alicia Williams shows you how to use Cloud Natural Language to analyze and interpret free-form text, directly in Google Sheets!

Snippet, Sheets

Log actions performed by a user running a Google Apps Script

Tags:
| |

Screenshot of spreadsheet with logs from script

Example log output from script to spreadsheet

A standalone function that you could include in your scripting projects to help determine which user ran a script and what actions it has performed. It is designed to output the information into a Google sheet – Date/Time, User, Action.

Source: The Gift of Script: Log actions performed by a user running a script

Solutions, Sheets

Retrieve Rows from Google Spreadsheet with Google Apps Script

Tags:
| | 0 Comments |

After answering 100’s of Google Apps Script questions, I realized how many projects people are working on that start with a Google Spreadsheet as a base. A lot of my existing examples involve using a Google Form to trigger scripts that do things to data being written to a spreadsheet, so I typically have to describe what to do using quick code snippets or links to other docs.

In this post, we look at the easiest way to retrieve all of the rows of data from a Google Spreadsheet using Google Apps Script.

Source: Retrieve Rows from Google Spreadsheet with Google Apps Script – Jeff Everhart

Solutions, Sheets

Building a shared password manager on Google Sheets

Tags:
| | 0 Comments |

Password managers have become an inevitable part of our online lives. The only way not to reuse a password is to use a password manager. Sharing over LastPass needs the user to know the other person’s email address and the receiving person need to have a LastPass account and have it installed. While I am a strong advocate of using password managers, I understand that everyone in a team might not be comfortable in doing so.

If we can use a shared secret to encrypt the password and save the encrypted text in the sheet, anyone who is looking for that password can just decrypt it using the shared secret. But everyone need to have the encrypt-decrypt tools installed. This takes us back to the original problem – everyone need to have the password manager installed. What if we could do this in Google Sheets itself?

Source: Building a shared password manager on Google Sheets