Google Form to Trello Board via Email

100%

Google Form to Trello Board via Email

✓ Published0🌍 Public

Last edited Feb 3, 2021

Created on Sep 5, 2016

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.

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

58% 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

54% match

Loading thumbnail…

Retrieve Google Spreadsheets content

This example shows a web page that pulls content from a published Google Spreadsheet and renders it as a numbered list of image cards with text and credit lines. The spreadsheet’s first two rows provide the headline and deck, while each subsequent row supplies an image URL, title, and credit. The code uses jQuery’s `$.getJSON` to fetch data from the Google Spreadsheets feed API, parses the returned JSON, and dynamically appends HTML elements to a container. It relies on a single function, `buildList`, which takes the spreadsheet ID as an argument, and uses basic array storage and string interpolation to build the layout.

LLayne Smith

50% match

Loading thumbnail…

Gist 3742279

This example builds a small HTML form to trigger an interactive test of Google's Visualization API, version 1. The code defines a data table (`gAxesTable`) with three fictional axes, each given an id, label, title, and type. When the user clicks the "TEST" button, the script populates the page’s `result` div with the table’s JSON representation via `google.visualization.DataTable` and its `toJSON()` method. The demonstration focuses on how to initialize the API and serialize structured data for display.

RRCura

50% match

Loading thumbnail…

Gist 6701427

This visualization is a step-by-step HTML email template demonstrating 12 best practices for coding robust emails that render consistently across major email clients, including Gmail, Yahoo, Outlook, and Lotus Notes. The example uses nested tables, inline styles, and spacer cells to control layout, with explicit width/height attributes on images and `display:block` to prevent rendering quirks. It illustrates techniques such as treating the outer table as the body, avoiding line-height-sensitive tags, using HTML/CSS mixtures for typography, and adding a "no pictures" fallback header. A sample email structure is shown, with a header, grey shadow box, main content area, and footer, all built from table-based layouts with fixed widths and background colors.

FFasani

48% 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

48% match

Loading thumbnail…

D3 + leaflet + GForm

This example combines D3.js, Leaflet, and the Google Maps Geocoding API to visualize geocoded data from a Google Form spreadsheet on an interactive map. Circles are drawn on a Leaflet map using D3, with their positions updated based on the map view. The circles' fill colors correspond to categories in the data, and hovering over a circle triggers a smooth elastic transition that enlarges it, while clicking displays the venue's name, formatted address, and timestamp in an HTML tooltip panel. The map and circles animate in response to panning and zooming, and the data is loaded dynamically via Tabletop from a public Google Sheet.

FFedericopvs

47% 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

45% match