Backend Function Accessible via API to parse and process PDF
Budget: ₹400 – ₹750 INR
Create an application in JS or Python that receives via API a pdf document up to 500 pages. The function will query a google spreadsheet. Login credentials will be stored as environmental variables. The sheet will have multiple sheets of the same structure and the name of the individual sheet will match a field in the document.
The sheet will contain names.
The application will perform several tasks.
1) Determine the name of the Company issuing the K-1.
2) Create a a subfolder of a master folder in Google Drive (URL of the master folder will be stored as an environmental variable). The name of the subfolder will be based on the name of the specific title and the previous year.
3) On all pages with a specific title (Schedule K-1) it will extract the name, address and Tax ID from the page, create a new csv file with all the data organized in a simple table and upload the csv to the newly created folder.
4) Based on the names of the original sheet, the pdf will be divided based on the following formula:
for all names in sheet:
create new blank pdf called K-1 [company name] - [name], [year]
for all pages in pdf:
if page has name then append to new pdf
if page does not have a name on it and more recent page has name, append to pdf
upload pdf to new folder
5) create a way to check that all pages were extracted and appended to another pdf and report to an email address (stored as an environmental variable) the missing pages
The sheet will contain names.
The application will perform several tasks.
1) Determine the name of the Company issuing the K-1.
2) Create a a subfolder of a master folder in Google Drive (URL of the master folder will be stored as an environmental variable). The name of the subfolder will be based on the name of the specific title and the previous year.
3) On all pages with a specific title (Schedule K-1) it will extract the name, address and Tax ID from the page, create a new csv file with all the data organized in a simple table and upload the csv to the newly created folder.
4) Based on the names of the original sheet, the pdf will be divided based on the following formula:
for all names in sheet:
create new blank pdf called K-1 [company name] - [name], [year]
for all pages in pdf:
if page has name then append to new pdf
if page does not have a name on it and more recent page has name, append to pdf
upload pdf to new folder
5) create a way to check that all pages were extracted and appended to another pdf and report to an email address (stored as an environmental variable) the missing pages