I need paid help (hopefully 2-4 hours or less on a workflow shown below.
User visits a webform that allows PDF/JPG file uploads (tax docs) along with a checkbox set allowing user to state whether a condition existed in 2020 (bought a home etc).
That data is sent to Zapier via a webhook. (Currently, only 20% of possible file upload options are being seen by Zapier during testing). The Zapier Zap needs to:
Create a new Google Drive folder to accept the PDF(s) and then send the checkbox info (Checked or empty) to a Google Sheets database, along with basic user name/email data to match up.
A link to each uploaded PDF would need to be placed in the appropriate field in the spreadsheet corresponding to the user data entered on that new line of data: A Google Sheets spreadsheet already has approx 30 columns of data that should all contain on one line:
Name Email Phone - Bought a Home? Y/N Uploaded 1040 (link to PDF) etc
I want to oversee this and “direct you” in real time to build out the integration via Zoom. We have a few other Zaps that will need to be built if this one is built successfully. (Recurring jobs… a LOT!) Reply with hourly you’d want and experience level with Zapier/Google Drive.