Gmail + Google Sheets + Formatter by Zapier
Store new incoming Gmail addresses in Google Sheets
If you need to keep track of contact data as it comes into your inbox, this is the integration for you. It automatically captures a sender's email address as soon as a new email comes into your Gmail account, then sends that detail to a row in a specified Google Sheets spreadsheet.
If you need to keep track of contact data as it comes into your inbox, this is the integration for you. It automatically captures a sender's email address as soon as a new email comes into your Gmail account, then sends that detail to a row in a specified Google Sheets spreadsheet.
- When this happens...New Email
Triggers when a new email appears in the specified mailbox.
- automatically do this...Text
Work with text data to find & replace, capitalize, remove HTML, and more (with line-item support).
- then do this!
- Free forever for core features
- 14 day trial for premium features & apps
About Gmail
One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Formatter by Zapier
Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.