Fetch Daily Job Postings from Jsearch to Google Sheets and Telegram

This n8n workflow automates the process of fetching daily job postings from the Jsearch API, storing them in a Google Sheet, and notifying a Telegram chat about new listings. It's designed to keep you updated on relevant job opportunities without manual searching.

What it does

1. Schedules Execution: The workflow runs daily at a specified time (e.g., 9:00 AM).
2. Fetches Job Postings: It makes an HTTP request to the Jsearch API to retrieve job postings based on predefined criteria.
3. Processes API Response: The raw API response is processed to extract relevant job details.
4. Filters Existing Jobs: It reads existing job entries from a Google Sheet to prevent duplicate entries.
5. Identifies New Jobs: Compares the fetched jobs with existing ones to identify only the new postings.
6. Adds New Jobs to Google Sheet: New job postings are appended as new rows to a designated Google Sheet.
7. Formats Telegram Message: Each new job posting is formatted into a clear and concise message for Telegram.
8. Sends Telegram Notifications: For each new job, a separate message is sent to a specified Telegram chat.
9. Pauses Between Telegram Messages: A short delay is introduced between sending each Telegram message to avoid hitting API rate limits and ensure messages are delivered smoothly.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Jsearch API Key: Access to the Jsearch API for fetching job data.
• Google Account: A Google account with access to Google Sheets. You'll need to create a new spreadsheet or use an existing one for storing job data.
• Telegram Bot: A Telegram bot and its API token. You'll also need the Chat ID of the Telegram chat where you want to receive notifications.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click "New Workflow".
   • Go to "File" > "Import from JSON" and paste the code.
2. Configure Credentials:
   • HTTP Request (Jsearch API): Configure the HTTP Request node with your Jsearch API key and the desired job search parameters (e.g., keywords, location).
   • Google Sheets: Set up your Google Sheets credential. You'll need to specify the Spreadsheet ID and Sheet Name where the job data will be stored. Ensure the n8n service account has write access to this sheet.
   • Telegram: Set up your Telegram credential with your bot's API token and the Chat ID for notifications.
3. Activate the Workflow: Once all credentials and node settings are configured, activate the workflow. It will automatically run according to the schedule trigger.
4. Customize:
   • Schedule Trigger: Adjust the cron expression in the "Schedule Trigger" node to change the daily execution time.
   • Jsearch API Query: Modify the HTTP Request node's URL and parameters to refine your job search (e.g., different keywords, job titles, locations).
   • Google Sheet Structure: Ensure the "Google Sheets" node's "Write Header" option matches the columns you expect from the Jsearch API and how you want to store them.
   • Telegram Message Format: Customize the "Edit Fields" node before the Telegram node to change the content and formatting of the job notification messages.
   • Wait Time: Adjust the "Wait" node's duration if you need to change the delay between Telegram messages.