Moving row file attachments from SmartSheet to ClickUp

I am currently attempting to create a zap that is triggered when their is a new file attachment in a row in SmartSheet to push that file over to a specific task in ClickUp.

I cannot seem to figure out how to push the actual file from SmartSheet to ClickUp. No matter what I select, I end up with a .txt file in ClickUp after the Zap runs. Does anyone know how to make this work/work around this?

Page 1 / 1

Hi @AnduinAdmin

Help links for using Smartsheet in Zaps: https://zapier.com/apps/smartsheet/integrations#help

I can't select my Smartsheet attachments or discussions columns.

There isn't currently a way to match file attachments or discussions for Smartsheet Triggers or Actions.

Welcome to the Community, @AnduinAdmin!

Are you using the New Attachment trigger? If so, it looks like the Url field should contain a link to the file attachment:

Is that the field you’ve got selected currently?

Either way, can you share a quick screenshot showing the Configure section of the ClickUp action so we can take a closer look at what’s been selected for the file field? Make sure to blur or remove all personal information (names, emails, addresses etc.) from screenshots before sharing - you can use a tool like Zappy for that.

Looking forward to hearing from you!

Hi Sam,

Appreciate the details you shared! Yes, I am using the New Attachment trigger. I think the issue is the attachment in this case is a file attachment as opposed to a dropbox attachment, so a URL isn’t generated. I was hoping I would get a URL field in the scenario a file is being uploaded directly since when you open the file attachment in a new tab you are given an AWS link but that doesn’t appear to be surfaced in Zapier.

This is part of a customer intake process so we unfortunately can’t expect customers to use Dropbox, Drive, etc. where a url field would be reliably exposed.

Here are the fields I have available to me from the attachment:

Hi @AnduinAdmin,

I did some testing on my end and it seems like the file object is not available in the New Attachment trigger. However, we can use API Request (Beta) to fetch the attachment direct url. Here’s how:

Add the API Request (Beta) action.
We’re going to use the GET attachment from Smartsheet API: https://smartsheet.redoc.ly/tag/attachments#operation/attachments-get
Copy this URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/attachments/{attachmentId} and paste it in the “URL” field of the API Request (Beta) action.
Copy the Sheet ID from the trigger step. Like so:

(view larger)
Input the Sheet ID in the URL. Like so:

(view larger)
Map the Attachment ID from the trigger. Like so:

(view larger)
We can now map the Attachment URL to the subsequent steps of the Zap:

(view larger)