Skip to main content
100%

Gist 6fe95d260d540a3c985ea8e637b33a80

✓ Published0🌍 Public
Aallilevine
Last edited May 24, 2018
Created on May 24, 2018

This example shows a Google Apps Script workflow that automatically invites people to a Slack workspace when they submit a Google Form. It uses the SpreadsheetApp trigger API to listen for form submissions, the UrlFetchApp service to call Slack’s `users.admin.invite` endpoint with an admin token, and the GmailApp service to send email notifications about new sign-ups. The script also includes an initialization function that sets up the form-submit trigger, and it maps form response columns to email, inviter name, and timestamp fields.

AI-generated description

Similar vizzes

Loading thumbnail…

Assign edit url to spreadsheet and email link

This example shows a Google Apps Script that assigns edit URLs to a spreadsheet and emails them to form respondents. The script retrieves form responses and their edit response URLs, then writes those URLs as hyperlinks into a specified column of the linked spreadsheet. It uses the FormApp and SpreadsheetApp services to access the form and its destination sheet, matching timestamps to align responses with rows. Finally, it sends an email via the MailApp service containing the edit link, using the respondent’s email address from the first item response.

RRobinL
64% match
Loading thumbnail…

Google Form to Trello Board via Email

This example shows how to turn Google Form submissions into Trello cards by sending an email to the board’s private address. It uses the Google Apps Script `FormApp`, `MailApp`, and script triggers. The `onFormSubmit` function captures responses, assigns them to variables, builds a subject line and body, and sends the email via `MailApp.sendEmail`. A trigger runs the function on each form submission. The code relies on Trello’s email-to-board settings rather than the Trello API.

DDerekCaelin
64% match
Loading thumbnail…

Gist ea8710410afc9bb88a65f846e46d04da

This example demonstrates how to automate opening a Google Sheets tab in Chrome at user logon and session unlock, using a PowerShell script to register a Windows scheduled task. The task triggers on logon and session unlock events, launching Chrome with an app-mode URL pointing directly to the spreadsheet. The code constructs an XML task definition with the `Register-ScheduledTask` cmdlet, embedding the Chrome executable path and the spreadsheet URL as arguments. It highlights the use of PowerShell’s scheduled task API and XML trigger configuration, showing a practical workflow automation for persistent access to a specific data source without manual intervention.

HHerbCaudill
60% match
Loading thumbnail…

Gist f43601b1f490d87ec6f8

This example shows a Python script that downloads a Google Spreadsheet as a CSV file and prints its rows. The code defines a `Spreadsheet` class and a `Client` class that handles authentication via Google’s ClientLogin API, using `urllib` and `urllib2` for HTTP requests and `re` for parsing the authentication token. It then fetches the spreadsheet’s contents through the Google Sheets export feed, specifying the format as CSV and a worksheet ID, and parses the result with the standard `csv` module. The script demonstrates a straightforward command-line workflow for accessing spreadsheet data programmatically.

Aandybak
59% match
Loading thumbnail…

post-google-forms-nodejs

This example demonstrates how to submit form data directly to a Google Form using Node.js, bypassing the need for a browser interface. It shows a programmatic POST request that populates a form with fields such as size, email, delivery method, and address. The code uses the `superagent` library to send URL-encoded form data to the `/formResponse` endpoint of Google Forms. It explicitly maps each form field’s entry ID, like `entry.1721541334`, and includes both regular and "other" response options. The script logs the server response or any errors encountered during submission.

55un
57% match
Loading thumbnail…

Google Sheets Script for Fetching Data from Supabase

This example shows a Google Sheets script that pulls data from a Supabase database and writes it into the active sheet, first clearing existing content. It uses the Supabase REST API via `UrlFetchApp.fetch` and handles JSON responses with `JSON.parse`. The script writes a configurable set of headers to row one, then maps each data row into corresponding columns. It relies on `SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()` for sheet operations, and constants for the Supabase URL, anon key, and table name. The process is automated through a single `mainFunction` that chains clearing, header writing, and data fetching.

HHugoberry
55% match
Loading thumbnail…

Archive Gmail Regularly

This example shows a Gmail workflow for automatically archiving inbox messages based on age and category. Two Google Apps Script functions manage the process: `archiveInbox()` searches for threads older than two days that are not starred, while `batchArchiveCategories()` iterates through "social," "promotions," and "updates" tabs, moving threads older than one day in batches of 100. The script uses GmailApp’s `search()` and `moveThreadsToArchive()` methods, and a `runAll()` trigger schedules both routines regularly.

SSciutoAlex
54% match
Loading thumbnail…

google spreadsheet cheat sheet

This example shows a reference cheat sheet for common Google Sheets tasks, focusing on formulas that fetch external data. It demonstrates how to retrieve exchange rates using `GoogleFinance` and how to import cell ranges from another document using `importRange`. The code lists both full-range and single-cell import variations, with the data source specified by a spreadsheet ID and sheet range. The gist provides ready-to-copy formulas rather than a rendered visualization, emphasizing practical spreadsheet automation over graphical output.

Aabernier
54% match