Scribd
Upload
5 views2 pages

n8n Assignment

This document outlines an automation workflow using n8n to fetch data from a Google Sheet, search for people on LinkedIn, and extract their contact details. It includes steps for copying the information into an Excel sheet, marking the status in the Google Sheet, and sending automated emails through Gmail based on responses. The process repeats for each row in the input list and includes follow-up emails if no response is received.

Uploaded by

prathmesh.motm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views2 pages

n8n Assignment

This document outlines an automation workflow using n8n to fetch data from a Google Sheet, search for people on LinkedIn, and extract their contact details. It includes steps for copying the information into an Excel sheet, marking the status in the Google Sheet, and sending automated emails through Gmail based on responses. The process repeats for each row in the input list and includes follow-up emails if no response is received.

Uploaded by

prathmesh.motm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Create an automation workflow use n8n

Step 1:
Fetch or read a row data from a google sheet (Eg. input List).

Step 2:
Use this data to search people on linked with the key word Eg. Marketing Manager

Step 3:
Front the searched list of people profiles. Go through each profile starting with 1st. Eg.
Daniel Mason, Marketing Manager

Step 4:
Open the profile

Step 5:
Launch [Link] plugin in Chrome and copy the contact details like email and phone

Step 4:
Copy these details along with the profile details and paste it in table format into an
Excel Sheet (Eg. Lead contact form)

Eg.

Name Company Designation Email Id Phone Email Response


Number Sent

Step 6:
Mark the row data which was fetched in Input list google sheet as completed or add
completed text in the status column

Step 7:
Repeat Steps 1-6 for other rows in the input list google sheet

Step 8:
Use the email ids, name and send an automated mail 1, using gmail (eg. First mail)

Step 9:
Once the email is sent mark column as completed

Step 10:
If there is a response to the email, mark the response column as yes

If not send a follow email 2 using Gmail to the same address


Step 11:
If there is a response to the email, mark the response column as yes

If not send a follow-up email 3 using Gmail

You might also like