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

• [email protected]
• Linkedin
• YouTube