Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi!

My zap first creates a google sheet with some data, then locates the google sheet, and uploads it to Google Drive.

For some reason, my zap ran 3 times, with 2 fails and 1 success. After the run was complete, I see that the file was uploaded to Dropbox just fine, but the spreadsheet had exact same data 3 times, suggesting the automation tried to rerun itself three times, before finally successfully uploading to to Dropbox on the third try.

I’d like to troubleshoot why it error’d out the first 2 times and had a successful third. Here’s the error message I’m seeing and not quite sure what it is! 

Thank you!

 

 

Hi there @Hello123! 👋

Hmm, if it errored twice before running successfully with nothing changing in terms of what data was being sent to Dropbox I wonder if it might have been down to a temporary issue in connecting with Dropbox’s servers.

Looking at the status page for Dropbox here it appears that they were carrying out some maintenance on the day that the uploads were attempted: 
95b655db6174c39b871e57f302ec26a5.png
So I’m thinking that the maintenance might have being carried out during the first two attempts but had been finished by the time the third attempt to upload the file was made.

Do you think that could be the case here or are you still seeing similar occurrences of this behaviour?

Hi @SamB ,

 

Thanks for getting back to me! I’m still seeing the same behavior occur - it happened again on 2/2. I’ve also sent in a support ticket on that specific occurrence but no one’s gotten back to me yet (36+ hours now), would appreciate anything you can do to help look into the specific error!

Hi @Hello123 

Check your Zap Runs history details to see the DATA IN/OUT for each Zap steps.

The issue may be that NO file was found in GDrive in Step 8 to then upload in Step 9.

To help us have full context, post screenshots with how your Zap steps are outlined and configured.

 

 Hi @Troy Tessalone thank you!

Yesterday, the Zap executed again, this time it ran 9 times. 8 fails and 1 success. I’m confident that the Google file is found, and the error occurs in the final step of uploading to Dropbox.

 

Here’s a successful attempt:

Here’s a failed attempt. Note that there is no “data out” at all when it fails

If this is helpful, here’s the Data Out on the successful attempt.

id:	id:wSJSNqemQVwAAAAAAAIjmQ
file_name:	rredacted]
path:	eredacted]
file_ext:	.xlsx
size:	7.08 KB
modified:	2024-02-02T06:00:36Z
mime_type:	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
bytes:	7252
rev:	6105fd4b18e75a95399d1
revision:	6105fd4b18e75a95399d1
is_dir:	False
content_hash:	ebf5efedc4b4bf1c6bf5b2fb1b46c2e3cd53cce557c3283702454dab23f296f7
share_link:	https://www.dropbox.com/wredacted]
direct_media_link:	https://_redacted]
file_text:	Binary contents unsupported.
is_deleted:	false
is_shared:	true
file:	https://zapier-dev-files.s3.amazonaws.com/.redacted]

I might also have an additional clue. When I go into edit the zap and test the actual step of “Upload File to Dropbox,” the file is successfully uploaded, but the zap test shows it errored out. The file can be fully opened and has no problems. 

This error says “While requesting “dev_method” from Dropbox we ran into an error: File/Folder not found.” - despite the correct file being correctly uploaded to the correct location!

 

@Hello123 

Check the DATA OUT from the GDrive step and post screenshots from the failed Zap Run.

Hi @Troy Tessalone this is the logs and DATA OUT from the Gdrive step before the failed Dropbox upload!

 

 

id:	dredacted]
_zap_search_was_found_status:	true
kind:	drive#file
userPermission:
id:	me
type:	user
role:	owner
kind:	drive#permission
selfLink:	https://www.googleapis.com/drive/v2/files/eredacted]/permissions/me
etag:	":redacted]"
pendingOwner:	false
selfLink:	https://www.googleapis.com/drive/v2/files/eredacted]
ownerNames:
0:	0redacted]
lastModifyingUserName:	eredacted]
editable:	true
writersCanShare:	true
mimeType:	application/vnd.google-apps.spreadsheet
exportLinks:
application/x-vnd.oasis.opendocument.spreadsheet:	https://docs.google.com/spreadsheets/export?id=iredacted]&exportFormat=ods
text/tab-separated-values:	https://docs.google.com/spreadsheets/export?id=iredacted]&exportFormat=tsv
application/pdf:	https://docs.google.com/spreadsheets/export?id=iredacted]&exportFormat=pdf
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:	https://docs.google.com/spreadsheets/export?id=iredacted]&exportFormat=xlsx
text/csv:	https://docs.google.com/spreadsheets/export?id=iredacted]&exportFormat=csv
application/zip:	https://docs.google.com/spreadsheets/export?id=iredacted]&exportFormat=zip
application/vnd.oasis.opendocument.spreadsheet:	https://docs.google.com/spreadsheets/export?id=iredacted]&exportFormat=ods
parents:
0:
selfLink:	https://www.googleapis.com/drive/v2/files/eredacted]/parents/tredacted]-dredacted]
id:	dredacted]-dredacted]
isRoot:	false
kind:	drive#parentReference
parentLink:	https://www.googleapis.com/drive/v2/files/eredacted]-dredacted]
thumbnailLink:	https://lh3.googleusercontent.com/drive-storage/gredacted]-dredacted]=s220
appDataContents:	false
iconLink:	https://drive-thirdparty.googleusercontent.com/16/type/application/vnd.google-apps.spreadsheet
shared:	false
lastModifyingUser:
displayName:	eredacted]
kind:	drive#user
isAuthenticatedUser:	true
permissionId:	dredacted]
emailAddress:	sredacted]
picture:
url:	https://lh3.googleusercontent.com/a//redacted]=s64
owners:
0:
displayName:	eredacted]
kind:	drive#user
isAuthenticatedUser:	true
permissionId:	dredacted]
emailAddress:	sredacted]
picture:
url:	https://lh3.googleusercontent.com/a//redacted]=s64
copyable:	true
etag:	":redacted]"
alternateLink:	https://docs.google.com/spreadsheets/d//redacted]/edit?usp=drivesdk
embedLink:	https://docs.google.com/spreadsheets/d//redacted]/htmlembed?ouid=iredacted]
fileSize:	1024
copyRequiresWriterPermission:	false
spaces:
0:	drive
title:	eredacted]
labels:
viewed:	true
restricted:	false
starred:	false
hidden:	false
trashed:	false
explicitlyTrashed:	false
createdDate:	2024-02-02T06:00:23.759Z
modifiedDate:	2024-02-02T06:00:32.928Z
modifiedByMeDate:	2024-02-02T06:00:32.928Z
lastViewedByMeDate:	2024-02-02T06:00:32.928Z
markedViewedByMeDate:	1970-01-01T00:00:00.000Z
quotaBytesUsed:	1024
version:	7
capabilities:
canEdit:	true
canCopy:	true
file_ods:	hydrate|||.eJw1jstOwzAQRf_FC1ahebivRKpQVYSCkBCseGwiyx4npo5t7EnTUvXfcYrY3nPvmTkTbg2CwQZPDkhFtiQhygRkhkOjBKloWdLlYrVOCB8C2n4I4K8gzzNKs_kqIYxzO0TFf5otSpoQqUCLxrB-0kqlIZr3I_NtINWZDF7HuEN0oUpTYXmYtda2Gmbc9mlwHpgIHQCGFI7OerxTYpN_Sv7Rf4_vh1NHv9ayfl0ekcpDvdw9vdWPFJn78XZ7P6rn8eZv9mB9z3BjRYjnUaGevnlRBphzGnZsD7fFPCuyImJ57UY-tS-XX1NIX1o:1rVmbK:upclZT1owS8UWxzn2-K1lW41vL0|||hydrate
file_tsv:	hydrate|||.eJw1jstOwzAQRf_FC1ahebhNm0gVqopQEBKCFY9NZDnjxNSxjT1JWqr-O04R23vuPTNnwo1G0FjjyQIpyY5ERGqPTHOoZUNKWhQ0X603EeGDR9MPHtwVpGlCabJcR4Rxboag-E-TVUEjIiSoptasn7VCKgjmw8Rc60l5JoNTIe4QrS_juDHcL1pjWgULbvrYWwes8R0A-hiO1ji8k802_RT8o_-e3sdTR782onrNj0jFWOX7p7fqkSKzP87s7if5PN38zR6M6xlu0Y_hPEpU8zcvUgOzVsGeHeA2WyZZkgUsrt3A5_bl8gtYVF-I:1rVmbK:HGl7hgELOSpYeaMzBtmOCqpCgRg|||hydrate
file_pdf:	hydrate|||.eJw1jstOwzAQRf_FC1ahebivRKpQVYSCkBCseGwiyx4npo5t7EnTUvXfcYrY3nPvmTkTbg2CwQZPDkhFtiQhygRkhkOjBKloWdLlYrVOCB8C2n4I4K8gzzNKs_kqIYxzO0TFf5otSpoQqUCLxrB-0kqlIZr3I_NtINWZDF7HuEN0oUpTYXmYtda2Gmbc9mlwHpgIHQCGFI7OerxTYpN_Sv7Rf4_vh1NHv9ayfl0ekcpDvdw9vdWPFJn78XZ7P6rn8eZv9mB9z3DjhIznUaGevnlRBphzGnZsD7fFPCuyImJ57UY-tS-XX1DEX0I:1rVmbK:JCJDfLHJM_keuXG0Z4GT10sBtsw|||hydrate
file_xlsx:	hydrate|||.eJw1jstOwzAQRf_FC1ahebhNm0gVqopQEBKCFY9NZDnjxNSxjT1pUqr-O24Q23vuPTNnwo1G0FjjyQIpyY5ERGqPTHOoZUNKWhQ0X603EeGDR9MPHtwM0jShNFmuI8I4N0NQ_KfJqqARERJUU2vWX7VCKgjmw8hc60l5JoNTIe4QrS_juDHcL1pjWgULbvrYWwes8R0A-hgmaxzeyWabfgr-0X-P78dTR782onrNJ6TiWOX7p7fqkSKzP87s7kf5PN78zR6M6xluJ-WncB8lqus7L1IDs1bBnh3gNlsmWZIFLOZy4HP9cvkFH2JgbA:1rVmbK:XCjuy3a0taZkTiAk7MeOjsC4MNs|||hydrate
file:	hydrate|||.eJw1jstOwzAQRf_FC1ahebhNm0gVqopQEBKCFY9NZDnjxNSxjT1pUqr-O24Q23vuPTNnwo1G0FjjyQIpyY5ERGqPTHOoZUNKWhQ0X603EeGDR9MPHtwM0jShNFmuI8I4N0NQ_KfJqqARERJUU2vWX7VCKgjmw8hc60l5JoNTIe4QrS_juDHcL1pjWgULbvrYWwes8R0A-hgmaxzeyWabfgr-0X-P78dTR782onrNJ6TiWOX7p7fqkSKzP87s7kf5PN78zR6M6xluJ-WncB8lqus7L1IDs1bBnh3gNlsmWZIFLOZy4HP9cvkFH2JgbA:1rVmbK:XCjuy3a0taZkTiAk7MeOjsC4MNs|||hydrate
file_csv:	hydrate|||.eJw1jstOwzAQRf_FC1ahebhNm0gVqopQEBKCFY9NZDnjxNSxjT1JWqr-O04R23vuPTNnwo1G0FjjyQIpyY5ERGqPTHOoZUNKWhQ0X603EeGDR9MPHtwVpGlCabJcR4Rxboag-E-TVUEjIiSoptasn7VCKgjmw8Rc60l5JoNTIe4QrS_juDHcL1pjWgULbvrYWwes8R0A-hiO1ji8k802_RT8o_-e3sdTR782onrNj0jFWOX7p7fqkSKzP87s7if5PN38zR6M6xluuR_DeZSo5m9epAZmrYI9O8BttkyyJAtYXLuBz-3L5RdUel9m:1rVmbK:jB88tCgxoHuQKse7WP8qRmcPjWM|||hydrate
file_zip:	hydrate|||.eJw1jstOwzAQRf_FC1ahebhNm0gVqopQEBKCFZRNZDnjxNSxjT1p-lD_HaeI7T33npkL4UYjaKzxZIGUZEMiIrVHpjnUsiElLQqaL5ariPDBo-kHD-4G0jShNJkvI8I4N0NQ_KfJoqARERJUU2vWT1ohFQTzfmSu9aS8kMGpEHeI1pdx3BjuZ60xrYIZN33srQPW-A4AfQxHaxw-yGadfgm-63_Gz8Opo98rUb3nR6TiUOXbl4_qmSKzZ2c2j6N8He_-Zk_G9QzXZ2nDeZSopm_epAZmrYIt28N9Nk-yJAtY3LqBT-3r9RdWPF90:1rVmbK:VPSkud5NCD6RRTX5kPnh4aTAuvc|||hydrate

 

@Hello123 

Is the file being used a publicly accessible file?

Can you show screenshots with how your Box step is configured?

 

Help article for sending files in Zaps: https://help.zapier.com/hc/en-us/articles/8496288813453

Reply


Terms & Conditions