Unable to file Smartsheet attachments to Google Drive on my Zap.
I am trying to use the “Smartsheet Attachment to Google Drive” zap. I have it set up and it successfully sends text .txt files when I test the zap. However, when I add a file to the actual Smartsheet, nothing happens. From reading the help documentation, it appears that I am stuck at this part. I believe that I want to select “File” from that dropdown menu. But that is not an option. I have tried selecting every other option from the dropdown and it just generates a .txt file as part of the test, but nothing at all when I actually attach something to a row in the Smartsheet.
Some searching in common problems with Smartsheet on the Zapier help tells me:
“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.”
Basically, what I am trying to figure out is:
Does the “Smartsheet Attachment to Google Drive” actually work? Or is it not possible at all? If it does work, is there someone using it with advice?
Thank you,
Sara
Page 1 / 1
Hi @ReevesUnitedWay
Good question.
To help us have more context, please post detailed screenshots with how each Zap step is configured, thanks.
Try searching for “file” and see if there is a variable for: File (exists but not shown)
I have attached a PDF of all the steps up to the one where I cannot select File from the Insert Data option.
There is no option for File exists but is not shown. It just is not one of the options in that drop down menu. All the options are:
As you can see, the closest thing is Attachment Type: File...but that is just txt. data on what type of attachment and not the actual attached file.
Hi there @ReevesUnitedWay,
I’m jumping in to see if I can help!
I did some digging into this, and it seems like the “New Attachment” trigger for Smartsheet doesn’t supply a file object or a publicly accessible link to the attachment. We do have an open feature request for this exact functionality, and I have added you as another interested member to the feature request. That does a few things:
Bring this to the attention of the integration developers
Help track interest in this feature being implemented
Allows us to notify you via email if this feature becomes available in the future
While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!
In the meantime, you might want to use a couple of “API Request (Beta)” action for a workaround. Here’s what the Zap setup will look like:
Thanks for this answer. It is disappointing to learn the functionality doesn’t exist for the Zap. It seems strange to me that it would be an existing Zap that I just found doing a Google search, but that it doesn’t actually work.
I am not 100% clear how to try this beta you are recommending. It looks like I need to have three actions? After I put in the first action and hit test I get this error message:
Domain did not match expected domain filter `www.googleapis.com`.
So I was unable to continue to the other two actions.
Hi @ReevesUnitedWay,
Could you please share a screenshot of your setup? This is for me to take a closer look. You might be using the incorrect API Request (Beta) action based on the error you’re getting.
Thank you!
Attached is the screenshots.
Hi @ReevesUnitedWay,
I looked at the screenshots, and it looks like you’re using the API Request (Beta) for Google Drive. Could you please change that to API Request (Beta) for Smartsheet instead? Here’s a screenshot:
Thank you for helping with this. I am still experiencing issues.
I believe I am getting an error message in the Test phase of the second step (see all steps below).
Also, in your screenshot, it indicates the Data ID should be a field called Response Data Data ID. I don’t have such a field as an option. So I tried the field called Response Data Ref ID, as that was the only field with an ID. But I know that is not right.
Even if this was working, all I have done is connect it to my Smartsheet twice. I don’t see how I have provided any information about the Google Drive that I am trying to export the attachments to. So I am still not clear how this Zap will work.
I really appreciate your help!
Hi @ReevesUnitedWay,
Thanks for all the screenshots and additional information.
I've put together some screenshots and GIFs to guide you through the setup process:
Start by creating a new row with an attachment in the chosen Sheet in the "Trigger" section. Use this newly created row as your sample data.
For the trigger (New Row), you'll need to select the Sheet in the "Trigger" section of the trigger step and find the Sheet ID from there. Here's a handy screenshot to guide you: (view larger)
Moving on to the 2nd step, you'll need to input the Sheet ID from the selected Sheet from the trigger into the “URL” field of the API Request (Beta) in Smartsheet step. This step will fetch the attachment for the new row. It should look something like this: (view larger)
For the 3rd step, we're going to repeat what we did in the 2nd step, but with a different URL: https://api.smartsheet.com/2.0/sheets/PASTE THE SHEET ID HERE/attachments/MAP THE RESPONSE DATA DATA ID FROM THE 2ND STEP HERE. Then, map the "Response Data Data ID" from the 2nd step. Here's how it should look: (view larger)
Finally, in the Google Drive step, map the "Response Data URL" from the 3rd step. It should look like this: (view larger)
Hopefully, this clears everything out!
It is working!
This was super helpful. I didn’t realize that I could click to add the information to the URL. I thought I needed to type it in. I also thought the Row ID was the Row Number. I didn’t realize that the ID listed in the dropdown menu was for the row. Clearing that up really helped.
Thank you so much.
Sorry. An additional question. This is set up to happen when a new row is added. But my workflow is such that new attachments will be added to already existing rows. I made a duplicate Zap that changed the action from New Row to New Attachments. I am curious if that will work. I am not seeing that it is. When I re-test, I am seeing error codes in the output. And I am not sure if it is because the process needs to change for New Attachment in the other actions steps or if this process just doesn’t work for New Attachment.
This is from Step 2
Thank you!
Hi @ReevesUnitedWay,
I see! I apologize I completely missed your intended workflow. If that’s the case maybe we can try setting it up this way instead:
Action: Google Drive - Upload File - We’re going to map the “Response Data URL” from the 2nd step to the “File” field. Like so: (view larger)
Here’s the uploaded file from Google Drive: (view larger)
Please give this a try, and let me know how it goes!
This is super helpful. Does this mean that I do not need the third step that comes before the Upload File in Google Drive?
Right now the steps are:
Trigger
API Request (Beta) in Smartsheet
API Request (Beta) In Smartsheet
Upload File in Google Drive.
Can I remove that third step?
Hi @ReevesUnitedWay,
That’s correct! We'll be using just one API Request (Beta) in Smartsheet step. You'll simply need to use a different URL, just as I demonstrated in the GIF above.
The Zap setup will look like this:
Trigger: Smartsheet - New Attachement
Action: Smartsheet - API Request (Beta)
Action: Google Drive - Upload File
I hope this clarifies things for you! If you have any more questions, feel free to ask. Happy Zapping!
This has been outrageously helpful. It is working perfectly. Thank you.
Hi @ReevesUnitedWay,
You are most welcome!
I’m glad I was able to guide you and point you to the right direction.
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help!
Hi @ken.a
How would you download multiple attachments that are in a row?
Hi there @Meet!
Hopping in to see if I can help with this! It seems Smartsheet’s Get Attachment endpoint is only able to retrieve a single attachment not multiple attachments.
They have a List Attachments endpoint but that would only be able to pull all of the attachments for the sheet. It doesn’t appear possible to limit that request to pull all attachments for a specific row instead of the whole sheet.
The New Attachment trigger would trigger separately for each new attachment though so that should allow the Zap to see each attachment that’s added to the row.
Hope that helps to clarify things here. Please do let us know if we can help with anything else!
Hey @ken.a, I know it has been a few months since anyone last posted in this chat. I stumbled across this post and this is exactly what I am looking for. Although instead of uploading the attachments to Google Drive, I would like them to be uploaded to a Sharepoint/Teams site. I tried setting up a similar workflow, but I do not think the fields for “Upload File in Microsoft Sharepoint” work the same as “Upload file to Google drive”
I am very new to Zapier, although I have had some experience with Power Automate. Any help/suggestions would be greatly appreciate!
Hi @Travis.O,
The “Upload a File” in Microsoft Sharepoint action should be the as the Google Drive upload action. You’d need to map the file object or direct download URL to the “File” field.
