Announcements
Known issues updated. Learn more
Highlighted

When a File is Uploaded, Make a New Row in Google Sheets (viasocket.com)

New member | Level 2

I'm using the website viasocket to get info from the Frame.io API, into Google Sheets. I'd like to do the same thing with Dropbox.

I'd like to be able to pick a folder, and every time a file is uploaded into that folder, or one of its subfolder, I'd like to get the date & time, file name, and link to the file. Then I'd like to pass that into a new row on a Google Sheet.

I have a bad implementation of it working with IFTTT, but it's slow and doesn't work with subfolders.

Screenshot 2019-06-08 14.58.54.png

I can barely figure out how to begin. I had some info coming into socket using this: https://api.dropboxapi.com/2/files/list_folder. But each file had its own entry in an array, and I couldn't push that to Google SHeet.

I'm terrible at this. Please help!

4 Replies

Re: When a File is Uploaded, Make a New Row in Google Sheets (viasocket.com)

Dropboxer

Something to keep in mind in this scenario is that the current Dropbox webhook implementation listens for all changes to files and can't be set to listen on a single folder.

Do you have any code you've written (or can write) somewhere in your current flow? 

Reply
Loading...

Re: When a File is Uploaded, Make a New Row in Google Sheets (viasocket.com)

New member | Level 2

Just passing by to take a look at the new dropbox which looks awesome by the way winking face and decided to pick a random post for my good deed of the day.

@ericmlevy I can help you with that if you like. if you do not want to code and you think ITTT is not a good solution, try Zappier.

Let me know if you need help.

I do not work for Zappier by the way.

 

All the best!

Reply
Loading...

Re: When a File is Uploaded, Make a New Row in Google Sheets (viasocket.com)

New member | Level 2
Zapier can definitely do this, I was just trying to save $50/mo, since viasocket.com let’s you do something like 5,000 actions for free.

Our frame.io —> Google Sheets integration is working really well on there. That’s a simpler API though. Easier for a novice to understand.
Reply
Loading...

Re: When a File is Uploaded, Make a New Row in Google Sheets (viasocket.com)

New member | Level 2
I deleted the code I had written, because it wasn’t working.

I couldn’t get that loop to work at all. The documentation about it on the site is unclear to me, and all of my attempts to get it to work failed.

To be fair, I don’t know what I’m doing.
Reply
Loading...
API Support

Have a question? Our Dropbox Community is here to help you find an answer!
You won’t have to wait too long for a reply, but why not learn more about the Community while you’re here.

Not the right discussion for you? Find out what else our Community has to say about API Support.

Or, search our Help Center for even more.

Who's talking
Top contributors to this post