AppsScriptPulse

How marketing teams can use Google Apps Script to automate tasks and expand their JavaScript skills

Whether it’s event planning, research aggregation, budgeting, report creation, or reaching out to customers for campaigns; it’s helpful to be able to automate tasks using a script in Google Sheets for example.

Source: How marketing teams can use Google Apps Script to automate tasks and expand their JavaScript…

Build a Google Analytics dashboard 🖥️ with an Apps Script, a Sheets add-on, and Google Sites

If you help manage websites for your organization, and use Google Analytics, you can have data synced directly into a Google Spreadsheet on a routine basis (aka daily at 9am), by installing the Google Analytics add-on in your Sheet.

In addition to using the add-on, you can record your steps using a macro recorder and convert that into a custom menu that automates the setup of your report and creates a summary in chart form.

In this article I walk you through how to build a process to gather unique pageviews for this week, last week, this year, last year, regional location of audience, and top browsers used.

Source: Build a Google Analytics dashboard 🖥️ with an Apps Script, a Sheets add-on, and Google Sites

Create an Apps Script web app to collect phone numbers to text message customers updates 📟

In this article the author elaborates on how to create a basic interface using a standalone Apps Script (based on JavaScript and HTML) in order to collect phone numbers on your website, email signature, or wherever you can embed a URL of this web app and have the phone numbers input, delivered to your Google Sheet.

Source: Create an Apps Script web app to collect phone numbers to text message customers updates 📟

Auto-calculate rooms needed for a conference in a Google Sheet via an Apps Script

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.

Source: Auto-calculate rooms needed for a conference in a Google Sheet via an Apps Script

Send SMS event updates or discount codes using Twilio from a Google Sheet

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).

Source: Send SMS event updates or discount codes using Twilio from a Google Sheet

Send content automatically via a Google Sheet and an Apps Script | Sheets to Apps – YouTube

In this episode of Sheets to Apps, see why it can be handy to use a Google Form to help requestors receive assets like e-books or online white papers automatically by email using Apps Script.

Full tour of Google App Maker’s interface | Sheets to Apps – YouTube

We’ve gone over the basics of App Maker, but now it’s time to explore the interface further. Alexandrina Garcia-Verdin goes over how to utilize and modify tools and widgets, in this episode of Sheets to Apps!

Getting started, quickly build a basic app on Google App Maker – Sheets to Apps – YouTube

In this episode, we give you some brief examples of what kind of apps you can create with App Maker. Learn how to get started and quickly build a basic app on App Maker!

Subscribe to Apps Script Pulse...