• Home

    • Automation with Zapier

    • Automation inspiration

    Automation inspiration

    4 min read

    6 ways to automate OneDrive

    By Daniel Kenitz · June 19, 2023
    A hero image of the OneDrive app logo connected to other app logos on a light yellow background.

    In theory, digital storage should make file retrieval easy. In practice, we end up building our own mazes. Cloud storage gives us so many conveniences—like automated saving and remote off-site file backups—that we start saving everything. And that means what was a simple solution becomes complicated. Too many folders, too many file versions, too much repeat work when copying a file from one place to another.

    Microsoft's OneDrive is the antidote to this chronic over-storage problem. Designed to work on the backend of Microsoft's famous Office applications—think Word documents and Excel spreadsheets—it can make your entire cloud storage service function with the convenience of a local folder. 

    But that's if you only use Microsoft products. What if you want your OneDrive to be a one-stop shop for everything related to your file storage? You can use Zapier to plug OneDrive into almost everything you do.

    New to Zapier? It's workflow automation software that lets you focus on what matters. Combine forms, data tables, and logic with thousands of apps to build and automate anything you can imagine. Contact sales for more info on how to use this app, and thousands more, with Zapier.

    Table of contents

    • Synchronize OneDrive with other cloud storage apps

    • Connect OneDrive to email and chat tools

    • Send new documents to the right app or folder

    • Send files from OneDrive to social media

    • Save and manage video conferencing files

    • Connect OneDrive to your archive or spreadsheet app

    To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

    Synchronize OneDrive with other cloud storage apps

    In a perfect world, everyone would use the same cloud storage application. We'd effortlessly synchronize our work files and, file-finding would be a breeze. Unfortunately, that reality doesn't exist. But we can approximate it when we sync our OneDrive files with other cloud storage offerings.

    Let's say, for example, you prefer OneDrive, but you're working with a client who wants every project file in their Google Drive directory. You could theoretically save two copies every time you update the project files. But a good Zap means never having to do something twice. 

    Automatically connect your cloud storage drives by having Zapier upload new files to the directory of your choice. This works in whichever direction you want: uploading files from or to OneDrive. And it's easy to include popular cloud storage apps like Google Drive or Dropbox.

    Even better, you can point these Zaps exactly where you want files to go. Isolate a specific file folder in Google Drive or Dropbox, for example, and you'll only send those to OneDrive. This gives you more control over what ends up in your OneDrive. And more control means less clutter.

    Copy new Google Drive files to OneDrive

    Copy new Google Drive files to OneDrive
    • Google Drive logo
    • OneDrive logo
    Google Drive + OneDrive

    Upload OneDrive files for new files in folders in Dropbox

    Upload OneDrive files for new files in folders in Dropbox
    • Dropbox logo
    • OneDrive logo
    Dropbox + OneDrive

    Copy new OneDrive files to Google Drive

    Copy new OneDrive files to Google Drive
    • OneDrive logo
    • Google Drive logo
    OneDrive + Google Drive

    Upload OneDrive files for new updated Google Drive files

    Upload OneDrive files for new updated Google Drive files
    • Google Drive logo
    • OneDrive logo
    Google Drive + OneDrive

    Save files from email and chat—or send new files that way

    Most of the work we do these days has some degree of digital interaction stamped to it, whether that's chatting with someone at the office on Slack or sending a Gmail to a client. It would be nice if you didn't have to save new files and send manual notifications every time you've updated a file.

    So don't. You have a couple of options here. First, you can use Zapier to add files to your OneDrive while using email and chat clients—this means you don't have to go in and save the files manually. 

    Save new email attachments to OneDrive

    Save new email attachments to OneDrive
    • Email by Zapier logo
    • OneDrive logo
    Email by Zapier + OneDrive

    Save new Gmail attachments to OneDrive

    Save new Gmail attachments to OneDrive
    • Gmail logo
    • OneDrive logo
    Gmail + OneDrive

    Upload new Microsoft Outlook emails to OneDrive as files

    Upload new Microsoft Outlook emails to OneDrive as files
    • Microsoft Outlook logo
    • OneDrive logo
    Microsoft Outlook + OneDrive

    Upload OneDrive files for new files in Slack

    Upload OneDrive files for new files in Slack
    • Slack logo
    • OneDrive logo
    Slack + OneDrive

    Second, you can save a new file in OneDrive and have it automatically create notifications via Gmail, Outlook, or Slack so colleagues know there's been an update. This means one click can have multiple functions, both saving and sending files to the appropriate people.

    Send emails from Gmail for new files added to OneDrive

    Send emails from Gmail for new files added to OneDrive
    • OneDrive logo
    • Gmail logo
    OneDrive + Gmail

    Send emails in Microsoft Outlook for new OneDrive files

    Send emails in Microsoft Outlook for new OneDrive files
    • OneDrive logo
    • Microsoft Outlook logo
    OneDrive + Microsoft Outlook

    Send new OneDrive files to Slack as new messages

    Send new OneDrive files to Slack as new messages
    • OneDrive logo
    • Slack logo
    OneDrive + Slack

    Send new documents to the right app or folder

    Bookkeeping and file management are already hard enough. You shouldn't have to manually dig through folder after folder whenever you want to move a file from your OneDrive to another tool—or vice versa.

    Done right, these Zaps mean you can take business files and direct them to the appropriate folders for record keeping. Could you do this manually if you wanted to? Of course. But it would add an extra step, which only adds friction to bookkeeping. Instead, automate the process so that the next time you check your bookkeeping tool or OneDrive folder, it's full of every document you saved. 

    Copy new Google Docs documents to OneDrive files from a trigger

    Copy new Google Docs documents to OneDrive files from a trigger
    • Google Docs logo
    • OneDrive logo
    Google Docs + OneDrive

    Upload new documents for bookkeeping purposes from new files in OneDrive to Lexware Office

    Upload new documents for bookkeeping purposes from new files in OneDrive to Lexware Office
    • OneDrive logo
    • Lexware Office logo
    OneDrive + Lexware Office

    Upload PDF to OneDrive when PandaDoc documents are completed

    Upload PDF to OneDrive when PandaDoc documents are completed
    • PandaDoc logo
    • OneDrive logo
    PandaDoc + OneDrive

    Send files to social media

    If you're building a social media channel, you know how much work it can be. Filming new videos, taking new pictures, formatting them for social media—and that's before the busy work of uploading. Cut out the last step in your production process: use a folder in OneDrive to send new video files to YouTube or picture files to Facebook as soon as they're ready.

    Before you Zap your files onto social media, you'll have to make sure they're platform-ready. But if you've been publishing for quite a while, you probably already know how to prep the files. Create distinct folders for different social media channels and make publishing as quick as click-and-drag. Zapier will handle the rest.

    Upload YouTube videos from new OneDrive files

    Upload YouTube videos from new OneDrive files
    • OneDrive logo
    • YouTube logo
    OneDrive + YouTube

    Create Facebook Pages photos from new OneDrive files

    Create Facebook Pages photos from new OneDrive files
    • OneDrive logo
    • Facebook Pages logo
    OneDrive + Facebook Pages

    Share new OneDrive files on Pinterest

    Share new OneDrive files on Pinterest
    • OneDrive logo
    • Pinterest logo
    OneDrive + Pinterest

    Create OneDrive files from new Pinterest pins

    Create OneDrive files from new Pinterest pins
    • Pinterest logo
    • OneDrive logo
    Pinterest + OneDrive

    Save and manage video conferencing files

    Three certainties in life: death, taxes, and meetings. Yet applications like Zoom make meetings more convenient. You can record a Zoom meeting, so you always have a reference point for new projects, new clients, or simply to review meetings for your own reference.

    The best way to manage this? It's not by manually saving every new meeting file. Instead, set new recordings in Zoom to automatically upload to your OneDrive. You can designate the OneDrive folder you assign for this, which means your main storage folder won't be cluttered with files with names like ZoomMeeting10-19-2023.mp4. You can also set it to create new OneDrive folders to keep files separate.

    Create folders in OneDrive for new Zoom recordings

    Create folders in OneDrive for new Zoom recordings
    • Zoom logo
    • OneDrive logo
    Zoom + OneDrive

    For some extra capability, consider adding Descript to your pipelines. Descript creates transcripts from video files, making them easily searchable and quotable if you want to take Zoom meetings, turn them into interviews, and use them as inspiration for future content.

    Connect OneDrive to your archive or spreadsheet app

    Depending on what type of files you're storing in OneDrive or what info you need to keep track off, you might also use a spreadsheet or database app like Notion or Google Sheets to keep a record of which files you've kept and why they're important. With these Zaps, you can automatically create an archive of all new OneDrive files without adding an additional step to your workflow.

    Add Notion database items for new OneDrive files

    Add Notion database items for new OneDrive files
    • OneDrive logo
    • Notion logo
    OneDrive + Notion

    Create new Notion pages from newly added OneDrive files

    Create new Notion pages from newly added OneDrive files
    • OneDrive logo
    • Notion logo
    OneDrive + Notion

    Create rows in Google Sheets for new OneDrive folders

    Create rows in Google Sheets for new OneDrive folders
    • OneDrive logo
    • Google Sheets logo
    OneDrive + Google Sheets

    Add new OneDrive files to Microsoft Excel rows automatically

    Add new OneDrive files to Microsoft Excel rows automatically
    • OneDrive logo
    • Microsoft Excel logo
    OneDrive + Microsoft Excel

    As with the other solutions we've mentioned, the process also works in reverse. For example, you can create a new row in Google Sheets and have it create a new folder in OneDrive. This is great for organizing your OneDrive folders while using a program that offers a better visual layout.

    Create OneDrive folders for new Google Sheets spreadsheets

    Create OneDrive folders for new Google Sheets spreadsheets
    • Google Sheets logo
    • OneDrive logo
    Google Sheets + OneDrive

    Create folders in OneDrive for new rows in Microsoft Excel tables

    Create folders in OneDrive for new rows in Microsoft Excel tables
    • Microsoft Excel logo
    • OneDrive logo
    Microsoft Excel + OneDrive

    Create OneDrive folders for new Notion database items

    Create OneDrive folders for new Notion database items
    • Notion logo
    • OneDrive logo
    Notion + OneDrive

    Automate your storage solutions with Zapier

    You wouldn't think something as simple as file storage would be capable of so much. But Zapier and OneDrive together can turn an everyday action like saving a file into a cascade of effects. And given that the everyday file save is a task you'll repeat most often, building Zaps of your own can save you untold hours every year—without you even noticing it.

    Related reading:

    • 7 ways to automate OneNote with Zapier

    • 5 ways to automate Google Drive

    • 3 ways to keep your Dropbox organized—automatically

    Get productivity tips delivered straight to your inbox

    We’ll email you 1-3 times per week—and never share your information.

    tags
    mentioned apps

    Related articles

    Improve your productivity automatically. Use Zapier to get your apps working together.

    Sign up
    See how Zapier works
    A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'