Google Catalog PDF & Excel Automation
Budget: ₹1,500 – ₹12,500 INR
I manage my product catalogue through a custom Google Script and now need a seamless workflow that does two things:
1. Pull the catalogue data from the existing script-driven source and create a PDF that captures the entire layout and design. I’m looking for a custom-designed output rather than a simple export, so the script needs to handle styling, headers, footers, images, and any dynamic sections I define.
2. Immediately (or on demand) take that freshly generated PDF and convert it into a clean, well-structured Excel file for downstream analysis and inventory updates.
Please build this as a single Google Apps Script (or tightly integrated set of scripts) that I can trigger from my Google Drive. The flow should look like:
• Read data from my current “script google” catalogue.
• Render the PDF with my specified custom design.
• Save the PDF in Drive, then parse it into an .xlsx file, preserving tables, numbers, and text accuracy.
• Return both files to a designated folder and notify me once complete.
Acceptance criteria:
• PDF replicates the entire catalogue layout exactly as my custom template dictates.
• The Excel file contains all catalogue fields in proper columns, free of formatting artifacts.
• Script runs end-to-end with one click and includes clear inline comments so I can tweak it later.
If you’ve worked with Google Apps Script, HTML templates for PDF rendering, and PDF-to-Excel parsing libraries (e.g., Google Drive API, Advanced Drive Service, or a reliable third-party parser), you’ll be able to hit the ground running. Let me know your proposed approach and any libraries you’d lean on so we can wrap this up quickly.
1. Pull the catalogue data from the existing script-driven source and create a PDF that captures the entire layout and design. I’m looking for a custom-designed output rather than a simple export, so the script needs to handle styling, headers, footers, images, and any dynamic sections I define.
2. Immediately (or on demand) take that freshly generated PDF and convert it into a clean, well-structured Excel file for downstream analysis and inventory updates.
Please build this as a single Google Apps Script (or tightly integrated set of scripts) that I can trigger from my Google Drive. The flow should look like:
• Read data from my current “script google” catalogue.
• Render the PDF with my specified custom design.
• Save the PDF in Drive, then parse it into an .xlsx file, preserving tables, numbers, and text accuracy.
• Return both files to a designated folder and notify me once complete.
Acceptance criteria:
• PDF replicates the entire catalogue layout exactly as my custom template dictates.
• The Excel file contains all catalogue fields in proper columns, free of formatting artifacts.
• Script runs end-to-end with one click and includes clear inline comments so I can tweak it later.
If you’ve worked with Google Apps Script, HTML templates for PDF rendering, and PDF-to-Excel parsing libraries (e.g., Google Drive API, Advanced Drive Service, or a reliable third-party parser), you’ll be able to hit the ground running. Let me know your proposed approach and any libraries you’d lean on so we can wrap this up quickly.