Popular Dropbox and Google Sheets workflows and automations
Useful Dropbox and Google Sheets integrations
Triggers (If this)
- New spreadsheet added to folderThis trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- New file in your folderThis Trigger fires every time any file is saved in the folder you specify. NOTE: will process up to 15 files per polling period.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Any new shared file linkThis trigger fires every time a shared link for a file is created. Note: doesn't include folders.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- New text file in your folderThis Trigger fires every time any text file is saved in the folder you specify. NOTE: will process up to 15 files per polling period.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- New photo in your folderThis Trigger fires every time a photo is saved in the folder you specify. NOTE: will process up to 15 photos per polling period.
Queries (With)
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of photos in your folderThis query returns a list of every time a photo is saved in the folder you specify. NOTE: will process up to 15 photos per polling period.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of files in your folderThis query returns a list of every time any file is saved in the folder you specify. NOTE: will process up to 15 files per polling period.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of text files in your folderThis query returns a list of every time any text file is saved in the folder you specify. NOTE: will process up to 15 files per polling period.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- Find file by nameThis query returns a list of files searched by name you specify.
- History of spreadsheets added to folderThis query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- File metadataThis query returns the metadata of a file.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- List shared file linksThis query returns all shared file links. Note: doesn't include folders.
Actions (Then that)
- Revoke shared linkThis action will revoke the direct link to the file. Note: the file may still be accessible if there are shared links leading to any of the file parent folders.
- Add row to spreadsheetThis action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
- Add file from URLThis Action will download a file at a given URL and add it to Dropbox at the path you specify. NOTE: 30 MB file size limit.
- Update cell in spreadsheetThis action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
- Move file or folderThis action will move a file or a folder to new location.
- Create a text fileThis Action will create a new text file at the path you specify.
- Append to a text fileThis Action will append to a text file as determined by the file name and folder path you specify. Once a file’s size reaches 2MB a new file will be created.
Dropbox and Google Sheets resources
The 8 best apps for freelance writers in 2024
Explore our recommendations for the best apps for freelance writers and learn how you can build helpful automations quickly with IFTTT.
9 best Calendly integrations for small businesses
This blog by IFTTT provides helpful Calendly integrations to help small businesses reach their goals.
7 Harvest integrations to make time tracking a breeze
Learn about our favorite Harvest integrations and how you can create workflow automations in minutes with IFTTT.
What is influencer marketing and how does it work?
Click to learn What is Influencer Marketing and How Does it Work?
Automations for teachers
From homework tracking to sharing photos with parents, as well as creating custom voice responses for your classroom, IFTTT has the ability to save you time every day. Additionally, existing integrations with Google Drive, Google Sheets,...
How to make a graph or chart in Google Sheets
In this article, we will show you how to make graphs in Google Sheets. We will also introduce you to IFTTT, which can help automate your workflow and save you time. Let's get started!
Slack vs Discord - Best Chat App
Slack and Discord are the worlds most popular Chat apps. Click to learn which chat app to choose, Slack vs Discord.
5 best cloud storage apps to access docs easily
Find the best cloud storage apps for accessing your content easily and learn how IFTTT can help you integrate your cloud storage with other tools you love.
Automations for students 2024
Save yourself time that is often spent getting organized and managing your schedule by automating elements of the manual tasks you need to do. Out of the hundreds of services available on IFTTT, we integrate with many of the popular...