Build a Serverless Smartsheet‑to‑PDF Pipeline (Python + AWS Lambda)

---

---

Project Overview Our nonprofit produces a large grant reports every month with multiple points of entry. Staff upload evidence files (PDFs, docs) and update a brief narrative directly in Smartsheet. I want a hands‑off solution that: 1. Listens for row edits/attachments via a Smartsheet webhook 2. Pulls the changed rows, fills a multi‑line “Narrative” form field inside a PDF template 3. Merges that freshly filled template with all supporting PDFs—in contract order, with coversheets 4. Drops the final packet into an S3 bucket & re‑attaches it to a “Reports” sheet row 5. Keeps every version in S3 and logs each run (timestamp, row count, file size) Once built, any staff edit should automatically trigger a brand‑new merged PDF—no manual clicks or Adobe Acrobat needed. Responsibilities & Deliverables Design IaC (CDK/SAM) for API Gateway → Python Lambda → S3 Implement secure Smartsheet + AWS credentials with Secrets Manager Write the Lambda: Fetch changed rows & attachments via smartsheet-python-sdk Fill the PDF template using Adobe PDF Services SDK or pdfrw   Merge PDFs with pypdf, add bookmarks, name file Attachment_VII_YYYY‑MM.pdf Upload to S3 (versioned) and attach back to Smartsheet Basic error handling & CloudWatch logs; SNS/e‑mail alert on failure README + setup docs so we can redeploy if needed (GitHub repo) Hand‑off walk‑through (1 video call) Ideal Freelancer: Solid Python (async/requests, PDF libs) Production experience with AWS Lambda, API Gateway, S3, IAM Familiar with webhooks & third‑party APIs (Smartsheet a plus) Writes clean, commented code and clear docs Project Type & Timeline: Kick‑off as soon as hired; target delivery ≤ 3 weeks Milestones: architecture approval → working Lambda on dev sheet → prod cut‑over I am also open to helpful suggestions or guidance.

Keyword: IT Support

Price: $2.0

AWS Lambda Amazon S3 Python Amazon Web Services Smartsheet