Writing GF submissions to a Google Sheet (via Zapier) but attachment link isn't correct

Get Help
, ,
1

I have a long form for Product and Report requests that our company uses to make IT requests for new features, reports, etc. The submissions are written to a Google Sheet via a Zapier Zap. It’s been working great.

We recently enabled the Gravity Forms Dropbox Add-On so the attachments to our forms would get stored in Dropbox rather than on our WordPress website. Here’s the problem: the submission on the Google Sheet is still showing a clickable link as if the attachment has been stored on WordPress. This problem isn’t happening in our email notifications — these provide the correct link to the attachment in Dropbox.

I don’t know if this is a problem with the Dropbox plugin, Gravity Forms, or my Zapier setup. I have gone through all three and cannot find any settings to adjust.

2

Hi Matthew. It sounds like the Zapier Add-On is sending the data to Google Sheets before Dropbox has accepted the file. Immediately after submission, the file upload field in the entry will show the location of the file on the web server, and then once the file is uploaded to Dropbox, the Dropbox Add-On will update that location in the entry.

This code snippet should delay the Zapier feed until after Dropbox is finished:

That is PHP code which can be added to your theme functions.php file, or you can use a plugin such as this one to keep the code separate from the theme: Code Snippets – WordPress plugin | WordPress.org

Please let us know if you need anything else.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.