PDF to Google sheet data extraction using Python or any scripting language
Budget: ₹600 – ₹1,500 INR
Hello,
I would like to have a automated tasker using Python(Panda, Camelot & Selenium) or any which you might think are better
Task of the Script as follows:
1. Get the active tasks from the webpage & make a sound if it reaches more than 3 open tasks
2. Open the active task & look for a web link, if available open the link & get the certain PDF's from there using dates of the uploaded time & name
3. After getting the files extract the data from Pdf's in the required format
Format:-
i. Customer Name & match the name with the folder name prior to downloading the files
ii. Score
iii. Date & match the date with current date
iv. Inquiries, should be segregated using the dates
v. Credits & Instalments should be segregated
vi. Collections(if available)
vii. Totals from the pdf & our data should be matched, if any variations an alarm or popup to rectify or confirm them 4. the extracted data should be pasted to a google sheet which i provide as it formatted
5. Copy the link of the sheet & paste a comment on the webpage & task list
6. Make a local database of Creditor names & a Selectable GUI for when the pdf is unreadable & in a image format
I have attached a sample pdf, the format would be different but majority of the data sets are same
Regards,
I would like to have a automated tasker using Python(Panda, Camelot & Selenium) or any which you might think are better
Task of the Script as follows:
1. Get the active tasks from the webpage & make a sound if it reaches more than 3 open tasks
2. Open the active task & look for a web link, if available open the link & get the certain PDF's from there using dates of the uploaded time & name
3. After getting the files extract the data from Pdf's in the required format
Format:-
i. Customer Name & match the name with the folder name prior to downloading the files
ii. Score
iii. Date & match the date with current date
iv. Inquiries, should be segregated using the dates
v. Credits & Instalments should be segregated
vi. Collections(if available)
vii. Totals from the pdf & our data should be matched, if any variations an alarm or popup to rectify or confirm them 4. the extracted data should be pasted to a google sheet which i provide as it formatted
5. Copy the link of the sheet & paste a comment on the webpage & task list
6. Make a local database of Creditor names & a Selectable GUI for when the pdf is unreadable & in a image format
I have attached a sample pdf, the format would be different but majority of the data sets are same
Regards,