Chrome Extension: Copy values from Jobinja and paste to Google Sheets

background.js

const SPREADSHEET_ID = '{{SHEET_ID}}';
const SHEET_ID = 123456789;
const RANGE = 'ApplicantsList!A2:L2';
//----------------------
chrome.runtime.onConnect.addListener(port => {
  port.onMessage.addListener(request => {
    if (request.action === 'copyValues') {
      const info = request.data;
      writeToGoogleSheets(SPREADSHEET_ID, RANGE, [info[0], 'To Call / Email - 1', '', 'Jobinja', info[4], '', info[1], '', '', info[3], '', info[2]]);
    }
  });
});
//----------------------
function getAccessToken(callback) {
  chrome.storage.local.get('accessToken', function (data) {
    if (data.accessToken) {
      callback(data.accessToken);
    } else {
      console.error('Access token not found in storage');
      callback(null);
    }
  });
}
//----------------------
function insertRowAtTop(sheetId, accessToken, callback) {
  const apiUrl = `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}:batchUpdate`;

  const requestOptions = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      'Authorization': 'Bearer ' + accessToken
    },
    body: JSON.stringify({
      requests: [
        {
          insertDimension: {
            range: {
              sheetId: SHEET_ID, // Assuming you want to insert the row on the first sheet
              dimension: 'ROWS',
              startIndex: 1, // Insert the row below the header (assuming the header is in the first row)
              endIndex: 2
            },
            inheritFromBefore: false
          }
        }
      ]
    })
  };

  fetch(apiUrl, requestOptions)
    .then(response => response.json())
    .then(data => {
      if (data.error) {
        console.error('Error inserting row:', data.error.message);
        callback(false);
      } else {
        console.log('Row inserted');
        callback(true);
      }
    })
    .catch(error => {
      console.error('Error inserting row:', error);
      callback(false);
    });
}
//----------------------
function writeToGoogleSheets(sheetId, range, values) {
  getAccessToken(function (accessToken) {
    if (!accessToken) {
      return;
    }

    // First, insert a new row at the top of the sheet below the header
    insertRowAtTop(sheetId, accessToken, function (success) {
      if (!success) {
        console.error('Failed to insert row');
        return;
      }

      // Next, write the data to the new row
      const sheetsApiUrl = `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${range}?valueInputOption=RAW`;

      const data = {
        range: range,
        majorDimension: "ROWS",
        values: [values]
      };

      const requestOptions = {
        method: 'PUT',
        headers: {
          'Content-Type': 'application/json',
          'Authorization': 'Bearer ' + accessToken
        },
        body: JSON.stringify(data)
      };

      fetch(sheetsApiUrl, requestOptions)
        .then(response => response.json())
        .then(data => {
          if (data.error) {
            console.error('Error writing to Google Sheets:', data.error.message);
          } else {
            console.log('Values written to Google Sheets');
          }
        })
        .catch(error => {
          console.error('Error writing to Google Sheets:', error);
        });
    });
  });
}

content.js

// Obtain an access token by completing the OAuth 2.0 flow outside of your Chrome extension.
// You can use the OAuth 2.0 Playground <https://developers.google.com/oauthplayground> for this purpose.
// Make sure to select the "https://www.googleapis.com/auth/spreadsheets" scope when configuring the playground.
const ACCESS_TOKEN = '{{YOUR_TOKEN}}';
setAccessToken(ACCESS_TOKEN);
//----------------------
var _buttonAdded = false;
//----------------------
main();
//----------------------
function main() {
  const jalaaliUrl = chrome.runtime.getURL('scripts/jalaali.js');
  loadScript(jalaaliUrl)
  .then(() => {
    init();
  })
  .catch((error) => {
    console.error('Failed to load Jalaali library:', error);
  });
}
//----------------------
var observeDOM = (function() {
  var MutationObserver = window.MutationObserver || window.WebKitMutationObserver;
  return function(obj, callback) {
    if (!obj || obj.nodeType !== 1) return; 
    if (MutationObserver) {
      // define a new observer
      var mutationObserver = new MutationObserver(callback)
      // have the observer observe for changes in children
      mutationObserver.observe(obj, { childList: true, subtree: true })
      return mutationObserver
    } else if (window.addEventListener) {
      // browser support fallback
      obj.addEventListener('DOMNodeInserted', callback, false)
      obj.addEventListener('DOMNodeRemoved', callback, false)
    }
  }
})()
//----------------------
function init() {
  // Observe a specific DOM element (<body> in this case)
  body = document.querySelector('body');
  observeDOM(body, function(m) {
    var addedNodes = [], removedNodes = [];
    m.forEach(record => record.addedNodes.length & addedNodes.push(...record.addedNodes))
    m.forEach(record => record.removedNodes.length & removedNodes.push(...record.removedNodes))
    console.clear();
    console.log('Added:', addedNodes, 'Removed:', removedNodes);
    observeOnAcceptance();
  });
}
//----------------------
function observeOnAcceptance() {
  const confirm = document.querySelector('[name="status-confirm"]');
  if (confirm != null && _buttonAdded == false) {
    _buttonAdded = true;
    addCopyPasteButton();
  } else if (confirm == null) {
    _buttonAdded = false;
  }
}
//----------------------
function addCopyPasteButton() {
  const button = document.createElement('button');
  button.innerText = 'Copy to Google Sheets';
  button.classList.add('btn', 'btn-default');
  button.addEventListener('click', extractApplicantInfo);
  const container = document.querySelector('div.btn-group.btn-group-lg');
  container.appendChild(button);
}
//----------------------
function extractApplicantInfo() {
  extractedInfo = [];
  // extract the name
  const nameElement = document.querySelector('div.d-inline-flex.align-items-baseline.align-items-sm-center.flex-wrap.flex-column.flex-sm-row');
  const name = getTextWithoutChildNodes(nameElement);
  extractedInfo.push(name);
  // extract the datetime
  const dirtyDateString = document.querySelector('span.d-none.d-sm-inline-block.fully-ltr').innerText;
  const cleanedDateString = cleanUpPersianDateString(dirtyDateString);
  const gregorianDate = persianToGregorian(cleanedDateString);
  extractedInfo.push(gregorianDate);
  
  info = document.querySelectorAll('div.fully-ltr.d-inline-block');
  for (i = 0; i < info.length; i++) {
    content = info[i].innerText
    if (content) {
      if (i == 0) {
        const latinNumber = content.replace(/[۰۱۲۳۴۵۶۷۸۹]/g, (match) => {
          return String.fromCharCode(match.charCodeAt(0) - 1728);
        }).replace(/^0+/, '');
        extractedInfo.push(latinNumber);
      } else {
        extractedInfo.push(content);
      }
    }
  }
  copyValues(extractedInfo);
}
//----------------------
function copyValues(info) {
  // Connect to the background script and send the values
  const port = chrome.runtime.connect();
  port.postMessage({ action: 'copyValues', data: info });
}
//----------------------
function setAccessToken(accessToken) {
  chrome.storage.local.set({ accessToken: accessToken }, function () {
    console.log('Access token saved');
  });
}
//----------------------
function getTextWithoutChildNodes(element) {
  let result = '';

  for (const node of element.childNodes) {
    if (node.nodeType === Node.TEXT_NODE) {
      result += node.textContent;
    }
  }

  return result.trim();
}
//----------------------
function persianToGregorian(persianDateString) {
  const persianDigits = '۰۱۲۳۴۵۶۷۸۹';
  const englishDigits = '0123456789';

  const englishDateString = persianDateString
    .split('')
    .map((char) => {
      const index = persianDigits.indexOf(char);
      return index === -1 ? char : englishDigits[index];
    })
    .join('');

  const [jYear, jMonth, jDay, hour, minute] = englishDateString.split(/[\/\s:]/);
  const gDate = jalaali.toGregorian(+jYear, +jMonth, +jDay);
  const gDateFormatted = `${gDate.gy}-${gDate.gm.toString().padStart(2, '0')}-${gDate.gd.toString().padStart(2, '0')}`;

  return gDateFormatted;
}
//----------------------
function loadScript(url) {
  return new Promise((resolve, reject) => {
    const script = document.createElement('script');
    script.src = url;
    script.onload = resolve;
    script.onerror = reject;
    document.head.appendChild(script);
  });
}
//----------------------
function cleanUpPersianDateString(input) {
  return input.replace(/[()]/g, '').trim();
}

jalaali.js

(function(f){if(typeof exports==="object"&&typeof module!=="undefined"){module.exports=f()}else if(typeof define==="function"&&define.amd){define([],f)}else{var g;if(typeof window!=="undefined"){g=window}else if(typeof global!=="undefined"){g=global}else if(typeof self!=="undefined"){g=self}else{g=this}g.jalaali = f()}})(function(){var define,module,exports;return (function(){function r(e,n,t){function o(i,f){if(!n[i]){if(!e[i]){var c="function"==typeof require&&require;if(!f&&c)return c(i,!0);if(u)return u(i,!0);var a=new Error("Cannot find module '"+i+"'");throw a.code="MODULE_NOT_FOUND",a}var p=n[i]={exports:{}};e[i][0].call(p.exports,function(r){var n=e[i][1][r];return o(n||r)},p,p.exports,r,e,n,t)}return n[i].exports}for(var u="function"==typeof require&&require,i=0;i<t.length;i++)o(t[i]);return o}return r})()({1:[function(require,module,exports){
/*
  Expose functions.
*/
module.exports =
  { toJalaali: toJalaali
  , toGregorian: toGregorian
  , isValidJalaaliDate: isValidJalaaliDate
  , isLeapJalaaliYear: isLeapJalaaliYear
  , jalaaliMonthLength: jalaaliMonthLength
  , jalCal: jalCal
  , j2d: j2d
  , d2j: d2j
  , g2d: g2d
  , d2g: d2g
  , jalaaliToDateObject: jalaaliToDateObject
  , jalaaliWeek: jalaaliWeek
  }

/*
  Jalaali years starting the 33-year rule.
*/
var breaks =  [ -61, 9, 38, 199, 426, 686, 756, 818, 1111, 1181, 1210
  , 1635, 2060, 2097, 2192, 2262, 2324, 2394, 2456, 3178
  ]

/*
  Converts a Gregorian date to Jalaali.
*/
function toJalaali(gy, gm, gd) {
  if (Object.prototype.toString.call(gy) === '[object Date]') {
    gd = gy.getDate()
    gm = gy.getMonth() + 1
    gy = gy.getFullYear()
  }
  return d2j(g2d(gy, gm, gd))
}

/*
  Converts a Jalaali date to Gregorian.
*/
function toGregorian(jy, jm, jd) {
  return d2g(j2d(jy, jm, jd))
}

/*
  Checks whether a Jalaali date is valid or not.
*/
function isValidJalaaliDate(jy, jm, jd) {
  return  jy >= -61 && jy <= 3177 &&
          jm >= 1 && jm <= 12 &&
          jd >= 1 && jd <= jalaaliMonthLength(jy, jm)
}

/*
  Is this a leap year or not?
*/
function isLeapJalaaliYear(jy) {
  return jalCalLeap(jy) === 0
}

/*
  Number of days in a given month in a Jalaali year.
*/
function jalaaliMonthLength(jy, jm) {
  if (jm <= 6) return 31
  if (jm <= 11) return 30
  if (isLeapJalaaliYear(jy)) return 30
  return 29
}

/*
    This function determines if the Jalaali (Persian) year is
    leap (366-day long) or is the common year (365 days)

    @param jy Jalaali calendar year (-61 to 3177)
    @returns number of years since the last leap year (0 to 4)
 */
function jalCalLeap(jy) {
  var bl = breaks.length
    , jp = breaks[0]
    , jm
    , jump
    , leap
    , n
    , i

  if (jy < jp || jy >= breaks[bl - 1])
    throw new Error('Invalid Jalaali year ' + jy)

  for (i = 1; i < bl; i += 1) {
    jm = breaks[i]
    jump = jm - jp
    if (jy < jm)
      break
    jp = jm
  }
  n = jy - jp

  if (jump - n < 6)
    n = n - jump + div(jump + 4, 33) * 33
  leap = mod(mod(n + 1, 33) - 1, 4)
  if (leap === -1) {
    leap = 4
  }

  return leap
}

/*
  This function determines if the Jalaali (Persian) year is
  leap (366-day long) or is the common year (365 days), and
  finds the day in March (Gregorian calendar) of the first
  day of the Jalaali year (jy).

  @param jy Jalaali calendar year (-61 to 3177)
  @param withoutLeap when don't need leap (true or false) default is false
  @return
    leap: number of years since the last leap year (0 to 4)
    gy: Gregorian year of the beginning of Jalaali year
    march: the March day of Farvardin the 1st (1st day of jy)
  @see: http://www.astro.uni.torun.pl/~kb/Papers/EMP/PersianC-EMP.htm
  @see: http://www.fourmilab.ch/documents/calendar/
*/
function jalCal(jy, withoutLeap) {
  var bl = breaks.length
    , gy = jy + 621
    , leapJ = -14
    , jp = breaks[0]
    , jm
    , jump
    , leap
    , leapG
    , march
    , n
    , i

  if (jy < jp || jy >= breaks[bl - 1])
    throw new Error('Invalid Jalaali year ' + jy)

  // Find the limiting years for the Jalaali year jy.
  for (i = 1; i < bl; i += 1) {
    jm = breaks[i]
    jump = jm - jp
    if (jy < jm)
      break
    leapJ = leapJ + div(jump, 33) * 8 + div(mod(jump, 33), 4)
    jp = jm
  }
  n = jy - jp

  // Find the number of leap years from AD 621 to the beginning
  // of the current Jalaali year in the Persian calendar.
  leapJ = leapJ + div(n, 33) * 8 + div(mod(n, 33) + 3, 4)
  if (mod(jump, 33) === 4 && jump - n === 4)
    leapJ += 1

  // And the same in the Gregorian calendar (until the year gy).
  leapG = div(gy, 4) - div((div(gy, 100) + 1) * 3, 4) - 150

  // Determine the Gregorian date of Farvardin the 1st.
  march = 20 + leapJ - leapG

  // return with gy and march when we don't need leap
  if (withoutLeap) return { gy: gy, march: march };


  // Find how many years have passed since the last leap year.
  if (jump - n < 6)
    n = n - jump + div(jump + 4, 33) * 33
  leap = mod(mod(n + 1, 33) - 1, 4)
  if (leap === -1) {
    leap = 4
  }

  return  { leap: leap
          , gy: gy
          , march: march
          }
}

/*
  Converts a date of the Jalaali calendar to the Julian Day number.

  @param jy Jalaali year (1 to 3100)
  @param jm Jalaali month (1 to 12)
  @param jd Jalaali day (1 to 29/31)
  @return Julian Day number
*/
function j2d(jy, jm, jd) {
  var r = jalCal(jy, true)
  return g2d(r.gy, 3, r.march) + (jm - 1) * 31 - div(jm, 7) * (jm - 7) + jd - 1
}

/*
  Converts the Julian Day number to a date in the Jalaali calendar.

  @param jdn Julian Day number
  @return
    jy: Jalaali year (1 to 3100)
    jm: Jalaali month (1 to 12)
    jd: Jalaali day (1 to 29/31)
*/
function d2j(jdn) {
  var gy = d2g(jdn).gy // Calculate Gregorian year (gy).
    , jy = gy - 621
    , r = jalCal(jy, false)
    , jdn1f = g2d(gy, 3, r.march)
    , jd
    , jm
    , k

  // Find number of days that passed since 1 Farvardin.
  k = jdn - jdn1f
  if (k >= 0) {
    if (k <= 185) {
      // The first 6 months.
      jm = 1 + div(k, 31)
      jd = mod(k, 31) + 1
      return  { jy: jy
              , jm: jm
              , jd: jd
              }
    } else {
      // The remaining months.
      k -= 186
    }
  } else {
    // Previous Jalaali year.
    jy -= 1
    k += 179
    if (r.leap === 1)
      k += 1
  }
  jm = 7 + div(k, 30)
  jd = mod(k, 30) + 1
  return  { jy: jy
          , jm: jm
          , jd: jd
          }
}

/*
  Calculates the Julian Day number from Gregorian or Julian
  calendar dates. This integer number corresponds to the noon of
  the date (i.e. 12 hours of Universal Time).
  The procedure was tested to be good since 1 March, -100100 (of both
  calendars) up to a few million years into the future.

  @param gy Calendar year (years BC numbered 0, -1, -2, ...)
  @param gm Calendar month (1 to 12)
  @param gd Calendar day of the month (1 to 28/29/30/31)
  @return Julian Day number
*/
function g2d(gy, gm, gd) {
  var d = div((gy + div(gm - 8, 6) + 100100) * 1461, 4)
      + div(153 * mod(gm + 9, 12) + 2, 5)
      + gd - 34840408
  d = d - div(div(gy + 100100 + div(gm - 8, 6), 100) * 3, 4) + 752
  return d
}

/*
  Calculates Gregorian and Julian calendar dates from the Julian Day number
  (jdn) for the period since jdn=-34839655 (i.e. the year -100100 of both
  calendars) to some millions years ahead of the present.

  @param jdn Julian Day number
  @return
    gy: Calendar year (years BC numbered 0, -1, -2, ...)
    gm: Calendar month (1 to 12)
    gd: Calendar day of the month M (1 to 28/29/30/31)
*/
function d2g(jdn) {
  var j
    , i
    , gd
    , gm
    , gy
  j = 4 * jdn + 139361631
  j = j + div(div(4 * jdn + 183187720, 146097) * 3, 4) * 4 - 3908
  i = div(mod(j, 1461), 4) * 5 + 308
  gd = div(mod(i, 153), 5) + 1
  gm = mod(div(i, 153), 12) + 1
  gy = div(j, 1461) - 100100 + div(8 - gm, 6)
  return  { gy: gy
          , gm: gm
          , gd: gd
          }
}

/**
 * Return Saturday and Friday day of current week(week start in Saturday)
 * @param {number} jy jalaali year
 * @param {number} jm jalaali month
 * @param {number} jd jalaali day
 * @returns Saturday and Friday of current week
 */
function jalaaliWeek(jy, jm, jd) {
  var dayOfWeek = jalaaliToDateObject(jy, jm, jd).getDay();

  var startDayDifference = dayOfWeek == 6 ? 0 : -(dayOfWeek+1);
  var endDayDifference = 6+startDayDifference;

  return {
    saturday: d2j(j2d(jy, jm, jd+startDayDifference)),
    friday: d2j(j2d(jy, jm, jd+endDayDifference))
  }
}

/**
 * Convert Jalaali calendar dates to javascript Date object
 * @param {number} jy jalaali year
 * @param {number} jm jalaali month
 * @param {number} jd jalaali day
 * @param {number} [h] hours
 * @param {number} [m] minutes
 * @param {number} [s] seconds
 * @param {number} [ms] milliseconds
 * @returns Date object of the jalaali calendar dates
 */
function jalaaliToDateObject(
  jy,
  jm,
  jd,
  h,
  m,
  s,
  ms
) {
  var gregorianCalenderDate = toGregorian(jy, jm, jd);

  return new Date(
    gregorianCalenderDate.gy,
    gregorianCalenderDate.gm - 1,
    gregorianCalenderDate.gd,
    h || 0,
    m || 0,
    s || 0,
    ms || 0
  );
}

/*
  Utility helper functions.
*/

function div(a, b) {
  return ~~(a / b)
}

function mod(a, b) {
  return a - ~~(a / b) * b
}

},{}],2:[function(require,module,exports){
module.exports = require('./index.js');
},{"./index.js":1}]},{},[2])(2)
});

manifest.json

{
  "manifest_version": 1,
  "name": "Copy to Google Sheets",
  "version": "1.0",
  "description": "Copy values from Jobinja and paste to Google Sheets",
  "permissions": [
    "activeTab",
    "clipboardWrite",
    "identity",
    "scripting",
    "storage",
    "cookies"
  ],
  "content_scripts": [
    {
      "matches": [
        "https://panel.jobinja.ir/ethica-data/posts/*",
        "<all_urls>"
      ],
      "js": ["content.js", "jalaali.js"]
    }
  ],
  "web_accessible_resources": [
    {
      "matches": ["<all_urls>"],
      "resources": ["jalaali.js"]
    }
  ],
  "background": {
    "service_worker": "background.js"
  },
  "oauth2": {
    "client_id": "{{CLIENT_ID}}",
    "scopes": ["https://www.googleapis.com/auth/spreadsheets"]
  },
  "action": {
    "default_icon": {
      "48": "icon.png"
    },
    "default_title": "Copy to Google Sheets"
  },
  "icons": {
    "48": "icon.png"
  }
}