Latenode
OpenAI GPT Assistants
Gmail
Google sheets

AI-powered job search and tracking in Google Sheets

This workflow automates the job search process by leveraging the Adzuna job search API, GPT-3.5 language models, and Google Sheets to discover, analyze, and track relevant job listings.

It retrieves real-time job data from Adzuna, summarizes and scores the listings using AI, and logs the results in a Google Spreadsheet. This end-to-end solution streamlines the job discovery and application process, allowing users to efficiently find and apply for opportunities that match their skills and preferences.

Updated Apr 6, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
AI agents & chatbots

Workflow preview

What this template does

  • Retrieves real-time job listings from the Adzuna API
  • Analyzes job descriptions using GPT-3.5 language models
  • Scores job listings based on relevance to user preferences
  • Logs relevant job opportunities in a Google Spreadsheet
  • Provides a centralized and automated job search workflow

How it works

1
Trigger

Schedule Workflow

This workflow is triggered on a schedule to regularly automate the job search process.

2
Action

Set Job Title

The user configures the job title they want to search for, which will be used to fetch relevant job listings from the Adzuna API.

3
Action

Get Jobs from Adzuna

The workflow fetches real-time job listings from the Adzuna API based on the specified job title.

4
AI

Summarize Job

For each job listing, the workflow uses a GPT-3.5 language model to generate a concise summary of the job details.

5
AI

Score Job

The workflow also uses a GPT-3.5 language model to analyze and score the relevance of each job listing to the user's skills and preferences.

6
Action

Write Cover Letter

The workflow generates a personalized cover letter for the user to apply for each relevant job listing.

7
Action

Write to Google Sheets

Finally, the workflow stores the job details, summaries, scores, and cover letters in a Google Spreadsheet for the user to review and act on.

Setup guide

1

Add OpenAI Credential

1. In the Latenode Credentials panel, add a new credential for OpenAI. 2. Provide your OpenAI API key.

2

Configure Google Sheets Connection

1. In the Latenode Credentials panel, add a new credential for Google Sheets. 2. Authenticate your Google account and grant the necessary permissions to access your Google Sheets.

3

Set up Gmail Connection

1. In the Latenode Credentials panel, add a new credential for Gmail. 2. Authenticate your Gmail account and grant the necessary permissions to send emails.

4

Configure Adzuna Job Search

1. Add an Adzuna API node to your workflow. 2. Provide your Adzuna API credentials, including the App ID and API key. 3. In the node settings, configure the job search parameters, such as the job title(s) to search for.

5

Map Data Fields

1. Connect the output data from the Adzuna API node to the subsequent nodes in your workflow. 2. Map the relevant job data fields (e.g., job title, description, company) to the input fields of the Summarize Job, Score Job, Write Cover Letter, and Google Sheets nodes.

Requirements

Adzuna API key to access their job search API
OpenAI API key to use the GPT-3.5 language model for job listing analysis
Google Sheets API access to create and update a job tracking spreadsheet
Google account with access to the Google Sheets workspace where the job tracking spreadsheet will be created

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
AI agents & chatbots

Automate Slack messaging with OpenAI GPT-3 completions

This automation allows users to automatically generate and send Slack messages based on specific prompts or triggers, leveraging the power of OpenAI's GPT-3 API. The automation is designed for AI, agents, and chatbot enthusiasts who want to create dynamic and personalized Slack communications without manual intervention. The automation connects to the Slack API and OpenAI's GPT-3 API to generate and send messages in response to defined triggers, such as specific keywords or phrases. This can be useful for automating routine updates, responding to customer inquiries, or generating creative content for Slack channels.

26s$0.0703
AI agents & chatbots

Transcribe Google Drive audio to text and send via email

This automation template helps users transcribe audio files stored in their Google Drive using the OpenAI Whisper AI model, and then automatically deliver the transcribed text via email. It provides a convenient way to convert audio recordings into text-based content that can be easily shared and referenced. The workflow is manually triggered, requiring the user to specify the Google Drive folder containing the audio files. The template then retrieves the files, transcribes them using the OpenAI Whisper API, and constructs an email message with the transcribed text, which is then sent to the designated recipient.

8s$0.0005
AI agents & chatbots

Automate Google Ads copywriting across multiple campaigns

This automation solution allows users to generate Google Ads headlines and descriptions directly within Google Sheets, using the OpenAI API to automate the ad copywriting process across multiple campaigns. The tool streamlines ad creation by leveraging AI-powered text generation, enabling marketers to efficiently produce high-performing ad copy at scale. By integrating with Google Sheets and the OpenAI API, this solution simplifies the ad creation workflow, saving time and improving campaign performance.

26s$0.0703