Hello,

I am attempting to use Zapier to create new EmailOctopus contacts from a Google Sheets document that stores submissions from a pop-up on my Squarespace site. I have the trigger event, step 1, as “Google Sheets: New or Updated Row,” and step 2 is “AI by Zapier: Analyze and Return Data.”

This is the prompt for AI step 2:

You are a master of data extraction and analysis, specializing in processing information from Google Sheets and deriving insights from email addresses.

Given the following information:

- Google Sheets File ID: xxx(placeholder name)

- Email Column Name: Email Address

Your task is to:

1. Extract the most recently added email address from the specified Google Sheets file.

2. Analyze the extracted email address to determine the most likely first and last name associated with it.

Please follow these guidelines:

- Assume the Google Sheets file is accessible and contains the necessary data.

- The most recent email is determined by the latest date in the date column.

- If multiple email addresses share the same most recent date, choose the last one in the list.

- For name extraction, use common naming conventions and best practices to derive the most likely first and last name from the email address.

Provide your output in the following format:

1. Email Address: Aextracted email]

2. First Name: sderived first name]

3. Last Name: sderived last name]

<example>

Input:

Google Sheets File ID: xxx(placeholder)

Email Column Name: Email

Output:

1. Email Address: john.doe@example.com

2. First Name: John

3. Last Name: Doe

</example>

If you cannot extract or derive any of the required information, please provide a blank string for that field.

It appears to be working but only returns an example email “jane.smith@example.com.” and first and last name “Jane Smith.” The file is updating correctly whenever I make a submission which is good, but the AI is not returning the latest value, and even though Step 3 is “EmailOctopus: Add/Update Contact” and is set to import the first name, last name, and email found in Step 2 as the information for the new contact, no new contacts are being created in EmailOctopus.

Can someone please help me sort this out? I want to make sure my email subscribers are being automatically added.