Moving row file attachments from SmartSheet to ClickUp

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:

1. Add the API Request (Beta) action.
2. We’re going to use the GET attachment from Smartsheet API: https://smartsheet.redoc.ly/tag/attachments#operation/attachments-get
3. 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.
4. Copy the Sheet ID from the trigger step. Like so:
   
   (view larger)
    
5. Input the Sheet ID in the URL. Like so:
   
   (view larger)
    
6. Map the Attachment ID from the trigger. Like so:
   
   (view larger)
    
7. We can now map the Attachment URL to the subsequent steps of the Zap:
   
   (view larger)
    

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Hey there, ​@AnduinAdmin 👋

Just wanted to circle back in here to check how you got on with Ken’s suggestion? 

Keen to make sure you’re all set on this! 🙂