Connect Gmail and Google Sheets

Gmail → Google Sheets: New Email Matching Search, New Attachment Received. Google Sheets → Gmail: New Row Added.

Workflow templates

Google Sheets · Gmail

Send personalized Gmail emails from new Google Sheets rows

Send one plain-text Gmail email for each new spreadsheet row. Prepare To, Subject and Body headers in row 1, then append one complete message per row. Use a single valid recipient address in To and non-empty Subject and Body cells. Connect Google Sheets and Gmail with permission to send email, browse to the source spreadsheet and worksheet, and keep the prepared mappings. Each row supplies its own recipient, subject and message, so workshop confirmations, internal updates and individual follow-ups can use different text. Includes a fictional English workshop example with German characters and line breaks. Activate and let the first poll establish a baseline before adding rows. Existing rows and later edits are not sent; a prepared Filter stops rows with missing To, Subject or Body cells. Skipped rows are not drafts or a pending queue, so prepare the full row before appending it. Do not delete or reorder rows while active. Emails are sent from the connected Gmail mailbox and recorded in Sent. HTML, attachments, Cc, Bcc and automatic signatures are not included. Only share the source worksheet with people allowed to send email from this account. Use a test worksheet and your own address for the first run. Gmail sending limits apply. This is individual message delivery, not a bulk campaign, scheduled digest or unsubscribe manager. Message IDs do not guarantee exactly-once delivery: manual reruns or ambiguous provider failures can send another email.

1. Google Sheets · New Row Added
2. Filter · Only send complete message rows
3. Gmail · Send the row as a plain-text email

View template →Use template

Gmail · Google Sheets

Log matching Gmail emails in Google Sheets

Build a searchable correspondence register from new inbox emails matching your Gmail search. Each matching email adds one row with Message ID, Sender, Subject, Received and Gmail URL. Prepare these exact headers in columns A-E, connect Gmail and Google Sheets, select the spreadsheet and worksheet, and review the prefilled search subject:"[Log]" before activating. Includes its own fictional English enquiry example. Values are written as plain text, preserving punctuation and preventing spreadsheet formula interpretation. Only newly received matching inbox messages are processed; historical messages and later label changes are not imported. Email bodies and attachments are not copied. This is an append-only register, not a two-way sync. Use a private worksheet because sender and subject information is copied there.

1. Gmail · New Email Matching Search
2. Google Sheets · Log matching email

View template →Use template

Gmail · Google Sheets

Import Gmail CSV attachments into Google Sheets

Import every row from a Gmail CSV attachment into Google Sheets. Formatter parses the file and maps id, name, email, amount and note to columns A–E. Choose your spreadsheet and worksheet with these headers, or adjust the mappings for your CSV. Includes a three-row CSV example. Only activate after checking the Gmail filter and destination.