Skip to main content

Hello, 

I created a Wix form, connected Wix and Google drive in Zapier, tested live and from this experience expect 4 things to happen:

  1. Wix sends an email with the completed application details (YES, complete)
  2. Wix uploads the documents into Wix media (YES,complete)
  3. Through Zapier, the application answers to transfer to a google spreadsheet (NO)
  4. Through Zapier, the document uploads to transfer to google drive (No, Haven’t set up yet as haven’t figure out #3)

The attachments below include the Zap for the Wix form and Google sheet setup and the Google worksheet waiting to be populated. 

What am I missing? I’ve deleted and reset up the zap several times, renamed the spreadsheet, and still nothing touches the Google worksheet.

Thanks!

 

Hi ​@ski999 

In the GSheet step, you need to map variables from Zap step 1 to the desired column fields.

 


Thank you Tony. The survey data transferred to the google worksheet; however, the documents didn’t upload to the google drive. Now that I’m starting to understand this morning, would that task require a separate Zap? 

Stacy


Thank you ​@Troy Tessalone. The survey data transferred to the google worksheet; however, the documents didn’t upload to the google drive. Now that I’m starting to understand this morning, would that task require a separate Zap? 


@ski999 

The previous screenshots you shared only had steps for Wix and GSheets.

We would need to see screenshots showing how your Zap steps are configure using GDrive.


@Troy Tessalone here is what I have so far.

 


@ski999 

Help link for using files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

If you are trying to transfer files from Wix to GDrive, then you will need at least another Zap step: GDrive - Upload File

Map the GDrive Folder ID between Zap steps.

 


@Troy Tessalone Thank you. To be more specific, the documents uploaded would vary by name and type. For example: one file name: Business Inc. investor pitch deck.pdf; another example:  Company LLC Advisory Board resumes.pdf; a third example: BizCo Ltd financial model.xlsx 

 

From what I can tell, it appears the file upload must be consistent. Did I get that right? 

 


@ski999 

Help link for how to configure Zap action steps: https://zapier.com/help/create/basics/set-up-your-zap-action

 

In fields, use the [+] button to map a dynamic variable from a previous Zap step.

 

For the Folder field, click the [...] button, choose “Custom” mode, then map the ID variable from Zap step 2, so the uploaded Files go into the GDrive Folder created in Zap step 2 each time the Zap Runs.

 

NOTE: If you will have multiple files you need to processes, then you will need to implement Looping: https://zapier.com/apps/looping/integrations#help

 

If you are considering hiring help, there is a directory of Certified Zapier Experts: https://zapier.com/experts

 

 


Hey ​@ski999, just checking in—were you able to get this sorted by using the Custom value option to select the ID, as Troy mentioned? Or did you reach out to a Zapier Expert for additional help? 

Keen to ensure you’re all set, so let us know if you still need any help! 🙂