Turn a simple lead list into personal emails at scale. New or updated rows in Google Sheets trigger social research, AI writing, and an email send, then the sheet is updated for tracking. Ideal for outbound teams that want fast and relevant messages without manual copy and paste.

Here is how it runs. A Google Sheets trigger watches for rows that have a LinkedIn URL, a Twitter handle, a name, and an email while the done field is empty. A Set node stores your company name and activity for the message. RapidAPI calls pull the Twitter user id, recent tweets, and LinkedIn posts. Code nodes trim each feed to a small set so the AI can focus on what matters. An OpenAI chat model with a structured parser returns a subject and a cover letter. The email node sends the message and CCs you, then the sheet marks the row as done.

To put this into action you need Google Sheets access, RapidAPI keys for the Twitter and LinkedIn endpoints, an OpenAI API key, and an SMTP email account. Expect to cut research and writing time from hours to minutes while keeping each email tied to real posts. Use it for cold outreach, partnership pitches, or event invites where social context boosts reply rates.

• Google Sheets trigger starts when a row is added or updated and the done field is empty.
• If node filters out completed rows so you avoid duplicate emails.
• RapidAPI Twitter calls get the user id from the handle and fetch recent tweets.
• RapidAPI Fresh LinkedIn Profile Data pulls recent posts from the provided LinkedIn URL.
• Code nodes trim and clean social content to a maximum of 10 items per source.
• Set node stores your company name and activity for consistent messaging.
• OpenAI chat model with a structured parser returns a subject and a cover letter.
• Email node sends the message to the lead and CCs you, then updates the sheet to mark done.

• Reduce manual research and writing from 1 hour per lead to about 5 minutes
• Streamline prospect research by using two social sources in one pass
• Improve personalization accuracy by referencing real posts and tweets
• Handle up to 10 times more leads per day with the same team
• Connect Google Sheets, social data, AI, and email in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, RapidAPI Twitter API, RapidAPI Fresh LinkedIn Profile Data, OpenAI and SMTP. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet with columns named linkedin_url, twitter_handler, name, email, and done. Leave done empty for new leads.
4. In the n8n credentials manager, create Google Sheets OAuth credentials. Connect the same Google account that owns or can edit the sheet.
5. Open the Google Sheets Trigger node and select your spreadsheet and worksheet. Set the trigger to watch for new or updated rows.
6. Double click the If node and confirm it checks that the done field is empty so only fresh rows move forward.
7. In n8n credentials, create an HTTP Header Auth credential for RapidAPI. Set the header name to x-rapidapi-key and the value to your RapidAPI key. Use this credential in both Twitter and LinkedIn HTTP Request nodes. The nodes already set the x-rapidapi-host header.
8. Open the Twitter HTTP Request nodes. Confirm the first call resolves the user id from the twitter_handler and the second call fetches tweets using that id.
9. Open the LinkedIn HTTP Request node and confirm it reads the linkedin_url from the trigger row and requests profile posts.
10. In the OpenAI Chat Model node, create or select an OpenAI API Key credential. Keep the model set to your preferred option and confirm the Structured Output Parser is linked.
11. Open the Set node and enter your company name, activity, and sender email. These values are used by the AI prompt and the email node.
12. In the Email Send node, create or select an SMTP credential. Use your provider host, port, username, and an app specific password if required. Set the To field to the lead email and add your email in CC.
13. Run a test by adding a new row to the sheet with valid social links and an email. Check that an email arrives and that the sheet updates the done field.
14. If you see no tweets or posts, verify the handles and URLs. Remove the at symbol from the Twitter handle, watch RapidAPI limits, and confirm your OpenAI key is active. Review node error messages for details.