Skip to content
Make Logo
  • Sign in
    Make logo
    Make platform
    Sign in to Make
    Integromat logo
    Legacy (Integromat)
    Sign in to Legacy
    • Get started free
    Google Sheets
    Gist

    Create Gist leads from Google Sheet rows

    About

    Share

    Every time a new row is added in Google Sheets, Make will automatically look a lead up in Gist using the email address. If the lead is not found it will create a new lead in Gist. This example uses (this sheet)[https://docs.google.com/spreadsheets/d/1I_0ORbuaKUyehO5qj7l3iWRNYELfAuG5lQzLfyuSw9A/edit#gid=0].

    Apps Included

    Google Sheets
    Google Sheets
    Gist
    Gist
    Get this template
    Categories
    Marketing Automation & Sales Funnels
    Email Marketing
    Help Desks
    Chat
    Get this template

    Similar templates for inspiration

    Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.

    Gmail
    Google Sheets
    Save a Gmail email containing a specific phrase to Google Sheets as a new row

    Use this template to save a Gmail message containing a specific phrase to your Google Sheets spreadsheet as a new row.

    Try It ➔
    Google Sheets
    Gmail
    Send a Gmail email from a new Google Sheets row

    Use this template to send a Gmail message when a new row is added to your Google Sheets spreadsheet.

    To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

    Try It ➔
    Facebook Lead Ads
    Google Sheets
    Add leads from Facebook Lead Ads to a Google Sheets spreadsheet

    Every time a new lead is collected from Facebook Lead Ads, Make will automatically add a new row with the lead's info to Google Sheets spreadsheet.

    Try It ➔
    Google Sheets
    Slack
    Share data added to a Google Sheet as Slack messages

    This automation grabs new rows of data from your Google Sheet and sends them as Slack messages.

    Try It ➔
    Google Sheets
    Telegram Bot
    Get Telegram messages for new Google Sheets rows

    Every time a new row is added to your Google Sheets spreadsheet, Make will automatically send a message in Telegram.

    Try It ➔
    Try It ➔
    Gmail
    Google Drive
    Google Sheets
    Save Gmail emails and attachments to Google Sheets and Google Drive

    Use this template to save a Gmail message to your Google Sheets spreadsheet as a new row and its attachments to Google Drive.

    Try It ➔
    Facebook Lead Ads
    Google Sheets
    Save new Facebook Lead Ads leads into Google Sheets

    When you get a new response to a Facebook Lead Ads form, it will be logged as a new row in Google Sheets.

    Try It ➔
    ScheduleOnce
    Google Sheets
    Add a new row to a Google Sheet when a new appointment is scheduled with ScheduleOnce

    Every time an appointment is scheduled with ScheduleOnce, Make will automatically add a new row to a Google spreadsheet.

    Try It ➔

    Create your own workflow

    Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

    All Modules (47)
    Google Sheets
    Add a Conditional Format Rule

    Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

    Action
    Google Sheets
    Add a Row

    Appends a new row to the bottom of the table.

    Action
    Google Sheets
    Add a Sheet

    Adds a new sheet.

    Action
    Google Sheets
    Clear Values from a Range

    Clears a specified range of values from a spreadsheet.

    Action
    Google Sheets
    Clear a Cell

    Cleares a specific cell.

    Action
    Google Sheets
    Clear a Row

    Clears values from a specific row.

    Action
    Google Sheets
    Copy a Sheet

    Copies a sheet to another spreadsheet.

    Action
    Gist
    Create Lead

    Creates a lead.

    Action
    Gist
    Create Tag

    Creates a tag.

    Action

    FAQ

    How do I get started with Make?
    What is a scenario?
    What is a module?
    What is mapping?

    Trusted by 500,000+ Makers