Scrupp addon formula WARMUP

Valeria / Updated 22 october

How to Use Google Sheets Add-on with WARMUP() Formula for Outreach

This tutorial will guide you step-by-step on using the WARMUP() formula, which formats and cleans data for outreach campaigns. This formula pulls data from specific columns in the current row, removes unnecessary symbols, and returns a formatted string suitable for outreach messages.

Step 1: Set Up Open AI API key

1. Install the Scrupp add-on for Google Sheets

 2. Go to OpenAI and create an account or log in if you already have it

 3. Go to the API keys page and create a new API key

 

Step 2: Set Up Google Sheets

1. Provide API key to the Scrupp addon and after saving click Activate account

2. Create or open a Google Sheet:

  • Create a new Google Sheet or open an existing one where you have Scrupp columns with headers like:
    • first_name
    • time_in_position
    • time_in_company
    • changed_job
    • job_details
    • latest_post
    • company_name
    • company_about
    • position

 

3. In a separate column type =WARMUP() formula

 

4. Select a column and click Cmnd + Enter (Alt + Enter) to launch formula on other rows

5. Create a new empty column and copy and paste the values from the formula column to avoid the next launches.

Give a name to a column like warmup and you can use this column in any email outreach tool like a variable to start a conversation.

 

In the outreach tool, you can insert the warmup message like a variable from the start, for example

[WARMUP]

Here the offer

Regards, John

So, at the end, you have a personalized message on another level, with unique text that increases trust with email providers, and personalization for every prospect, leading to a significant increase in conversion rate.

 

In today's competitive business landscape, access to reliable data is non-negotiable. With Scrupp, you can take your prospecting and email campaigns to the next level. Experience the power of Scrupp for yourself and see why it's the preferred choice for businesses around the world. Unlock the potential of your data – try Scrupp today!