Google Sheets Daily Data Comparison Script
Budget: ₹600 – ₹1,500 INR
I am seeking a proficient programmer to develop a Google Sheets script or function capable of automating the process of comparing data from one column with information extracted from a PDF file. Specifically, I require assistance with the following tasks:
Data Extraction: Extracting relevant data from a PDF file.
Data Comparison: Comparing the extracted PDF data with information stored in a specific column within Google Sheets.
Automated Data Entry: Automating the process of inputting specific values into designated cells within Google Sheets based on matches between the PDF data and Google Sheets data.
Serial Number Assignment: Implementing a counter to assign serial numbers based on the order of products listed in the PDF. For instance, the first product listed in the PDF would be assigned a serial number of 1, the second product would have a serial number of 2, and so forth.
Requirements:
Proficiency in Google Apps Script and JavaScript.
Experience with extracting data from PDF files.
Ability to efficiently manipulate and compare data within Google Sheets.
Strong communication skills and a proactive problem-solving approach.
Additional Information:
The format of the PDF files may vary, necessitating a flexible and adaptable script.
The script should be optimized for handling large datasets efficiently.
Serial numbers should be assigned based on the order of products listed in the PDF file.
Sample data and further details will be provided upon hiring.
If you possess the requisite skills and are interested in this project, please submit your proposal along with relevant experience and your estimated timeline and cost for completing the project. Thank you for considering this opportunity!
Data Extraction: Extracting relevant data from a PDF file.
Data Comparison: Comparing the extracted PDF data with information stored in a specific column within Google Sheets.
Automated Data Entry: Automating the process of inputting specific values into designated cells within Google Sheets based on matches between the PDF data and Google Sheets data.
Serial Number Assignment: Implementing a counter to assign serial numbers based on the order of products listed in the PDF. For instance, the first product listed in the PDF would be assigned a serial number of 1, the second product would have a serial number of 2, and so forth.
Requirements:
Proficiency in Google Apps Script and JavaScript.
Experience with extracting data from PDF files.
Ability to efficiently manipulate and compare data within Google Sheets.
Strong communication skills and a proactive problem-solving approach.
Additional Information:
The format of the PDF files may vary, necessitating a flexible and adaptable script.
The script should be optimized for handling large datasets efficiently.
Serial numbers should be assigned based on the order of products listed in the PDF file.
Sample data and further details will be provided upon hiring.
If you possess the requisite skills and are interested in this project, please submit your proposal along with relevant experience and your estimated timeline and cost for completing the project. Thank you for considering this opportunity!
Related categories:
PHP
Business, Accounting, Human Resources & Legal
JavaScript
Google App Engine
Google Chrome