AppsScriptPulse

Solutions, Sheets, Sites

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

Tags:
| | 0 Comments |

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

Solutions, Sheets, Web App

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

Tags:
| | 0 Comments |

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 📟

Solutions, Sheets

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

Tags:
| | 0 Comments |

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

Solutions, Sheets

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

Tags:
| | 0 Comments |

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

Solutions, Sheets

Analyzing Mailchimp Campaigns using Google Apps Script — PART II

Tags:
| | 0 Comments |

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.

Source: Analyzing Mailchimp Campaigns using Google Apps Script — PART II

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, 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

Using React + Google Sheets as your CMS

Tags:
| | 0 Comments |

I’ll start this tutorial by admitting you shouldn’t actually use Google Sheets as your CMS for a production level site or project. However…

By the end of this tutorial, you will be able to serve up any data from a Google Sheet into a real React app.

Source: Using React + Google Sheets as your CMS

Solutions, Drive, Sheets

Google Apps Script —Track videos viewed on Google Drive within your organization

Tags:
| | 0 Comments |

SCENERIO: You are admin of a G-Suite set up. You upload training videos for your organization members on Google Drive/Team Drive. To increase productivity, you want to ensure all members watch the videos you upload.

SOLUTION: You utilize this amazing GSuite Reports API and use Google Sheets as your dashboard to view all details about your MP4 videos.

Source: Google Apps Script —Track videos viewed on Google Drive within your organization