Although Google Sheets has more than 400+ built-in functions, I love to show folks how you can create custom functions that you can write for custom problems.
Whether it’s a dinner reservation confirmation, a discount code, or a status update via SMS; it’s handy to be able to use a Google Sheet as an interface where you enter desired phone numbers to text along with a unique message for each, especially if you need to concatenate or produce randomized data using formulas in a Sheet as the message.
In this article the author will walk you through how to use a Google Sheet to send text messages using Twilio’s free trial account (an online communications provider that offers texting, calling, etc).
So when you send out a campaign, Mailchimp tracks how many people opened the emails and which links were clicked within the email. So this information might not be available in a format you might like. So we will utilize the power of Mailchimp API and Google Sheets to put it in a format that we desire.
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.
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.
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.
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.
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!
