Template Information Who is this template for? This template is for users looking to retrieve email information from LinkedIn profiles and update Google Sheets with the collected data. 🎥 quick set up video How it works** The template utilizes a series of nodes to fetch email information from LinkedIn profiles. It starts with a Schedule Trigger node that sets the interval for the workflow. The Conditional Check node verifies if certain fields like Name, Gender, Job Title, Summary, and LinkedIn URL are not empty. The HTTP Request node sends a POST request to the specified URL with API key and profile information. The Data Merge node merges the data collected. The Field Editing node modifies the fields as needed. Finally, the Google Sheets Update node updates the Google Sheets with the gathered information. Set Up Instructions Make sure to have the necessary credentials and permissions for accessing LinkedIn and Google Sheets. Set up the API key required for the HTTP Request node. Configure the Google Sheets Update node with the appropriate document ID and sheet name. Check and adjust field mappings in the Field Editing node according to your needs.
Tags
Google SheetsWHTTP RequestRelated workflows
See all Google Sheets→W
Add data from a photo to Google Sheets
Automatically adding expense receipts to Google Sheets with Telegram, Mindee API, Twilio, and n8n.
WValidate & Enrich Phone Numbers in Google Sheets with RapidAPI
📞 Phone Number Validator with Google Sheets Validate and enrich phone numbers from Google Sheets using the phone number validator API. 📌 Use Case: Contact Validation & Enrichment Automatically check if phone numbers are valid and enrich them with metadata (country, location, timezone). Ideal for CRMs, lead management, and contact cleanup workflows. 🗂️ Google Sheets Columns | Column Name | Description | |-------------|-------------| | phone | The original phone number to validate (input column). | | is_valid | Result from API indicating if the phone number is valid (true / false). | | country | Country where the phone number is registered (e.g. "US"). | | location | More specific location info, such as city or region. | | timezone | The primary timezone associated with the phone number. | 🎯 Benefits ✅ Accurate Contact Data – Identify invalid or fake phone numbers automatically. 🌐 Geolocation Enrichment – Add country, location, and timezone for better segmentation. 🔁 Full Automation – No manual lookups or copying data between tools. 📊 Live Google Sheets Sync – Enriched data is updated directly into your spreadsheet. 🧠 Workflow Nodes Explained | Node | Purpose | |------|------
WTrack YouTube Trends by Country and Language with RapidAPI & Google Sheets
📈 YouTube Trend Finder Workflow using n8n & RapidAPI Description: Easily discover trending YouTube videos by country and language using this automated n8n workflow. The flow leverages the YouTube Trend Finder API and logs insights to Google Sheets — ideal for content creators, marketers, and researchers. 🔗 Node-by-Node Explanation | Node Name | Type | Description | |-----------------------------|--------------------|-----------------------------------------------------------------------------| | 1. On form submission | Form Trigger | Captures user input for country and language through a web form. | | 2. Trend Finder API Request | HTTP Request | Sends a request to YouTube Trend Finder API with the form data. | | 3. Re format output | Code | Extracts and reshapes API response data like title, link, and tags. | | 4. Google Sheets | Google Sheets | Appends the trending video data into a structured spreadsheet. | 🎯 Use Cases 🔍 Content Research: Find top-trending videos in any region or language for idea inspiration. 📈 Marketing Intelligence: Track video trends to tailor your video marketing strategy. 📰 Trend Monitoring: Journalists and analysts can quickly surface viral video top