Generate tailored CV and cover letter from job links with Google Sheets, Docs and OpenRouter

How it works This Workflow automatically creates a new CV and Cover Letter based on the job description and your Current CV.

How to set it up Create API keys for Google sheet Link, Google Docs Link and OpenRouter link -- If you do not know how to create and add an API key, then simply search on Google, and you will find a solution.

Create a new Google Sheet in your Google Drive with the name "Job IDs" and also add 3 columns with names "JobLink, CoverLetter, and CV." Then create a 2 Google Docs in your Google Drive with the names Cover Letter and CV. Linked them with the respective node in the workflow Add this code into Google sheet "APP Script" -> "function callN8n(e) { var range = e.range; if (range.getColumn() == 1) { // This is the combined URL from your terminal + n8n path var url = "https://pronounce-surround-curtsy.ngrok-free.dev/webhook/3d23f43d-9d38-45ba-9ad1-b696a2b97905";

var options = {
  "method": "post",
  "headers": {
    "ngrok-skip-browser-warning": "true"
  },
  "payload": JSON.stringify({
    "JobLink": e.value,
    "row": range.getRow()
  }),
  "contentType": "application/json"
};

UrlFetchApp.fetch(url, options);

} }"

Contact Detail dhaval.variya07@gmail.com Linkedin YouTube