?>

Google Drive + MongoDB Integrations

Appy Pie Connect allows you to automate multiple workflows between Google Drive and MongoDB

About Google Drive

Google Drive is one of the best file sync apps that let you store all of your files online alongside your Google Docs documents, and keep them synced with all of your devices.

About MongoDB

MongoDB is an open-source document-based database management tool that stores data in JSON-like formats. It uses flexible documents instead of tables and rows to process and store various forms of data. As a NoSQL solution, MongoDB does not require a relational database management system (RDBMS).

MongoDB Integrations

Best Google Drive and MongoDB Integrations

  • Google Drive Dropbox

    Google Drive + Dropbox

    Copy new Google Drive files in a specific folder to Dropbox Read More...
    When this happens...
    Google Drive New File in Folder
     
    Then do this...
    Dropbox Upload File
    Integrate your Dropbox and Google Drive with Appy Pie Connect, and make your life easier. This Connect can save you a lot of time every day by helping you store and organize your important files in a systematized manner. Once you’ve set up this integration, whenever a file is added to Google Drive, we will copy that file to the designated folder in Dropbox.
    How It Works
    • Triggers when a new file is added in Google Drive
    • This Connect automatically copies that file to a designated Dropbox
    What You Need
    • A Google Drive account
    • A Dropbox account
  • Google Drive Trello

    Google Drive + Trello

    Create Trello cards from new Google Drive files Read More...
    When this happens...
    Google Drive New File in Folder
     
    Then do this...
    Trello Create Card
    Get more out of your Google Drive by connecting it to Trello. After setting this integration up, whenever a new file is saved in a chosen folder in your Google Drive, Appy Pie Connect will automatically create a card in Trello. With this Trello and Google Drive integration, you can make your team collaboration more efficient.
    How It Works
    • Triggers every time a new file is saved to a chosen folder in your Google Drive
    • Appy Pie Connect automatically creates a new card in Trello
    What You Need
    • A Google account
    • A Trello account
  • Google Drive Dropbox

    Google Drive + Dropbox

    Copy new Google Drive files in any folder to Dropbox Read More...
    When this happens...
    Google Drive New File
     
    Then do this...
    Dropbox Upload File
    Setting up integration between your Dropbox and Google Drive can get you many extra productive hours every single day. After setting up this integration, whenever a new file is added on your Google Drive, Appy Pie Connect will copy that file to any folder in Dropbox.
    How This Integration Works
    • Triggers when a new file is added to Google Drive
    • Appy Pie Connect will automatically copy that file to any folder in Dropbox
    What Is Needed for This Integration
    • A Google Drive account
    • A Dropbox account
  • Google Drive Google Sheets

    Google Drive + Google Sheets

    Add rows on Google Sheets spreadsheet when a file is added in a Google Drive folder Read More...
    When this happens...
    Google Drive New File in Folder
     
    Then do this...
    Google Sheets Create Spreadsheet Row
    To keep your records straight, you might need a list of every new file added to a Google Drive folder. Set up this integration to watch your Google Drive folder and create a Google Sheets spreadsheet row when a new file is added. Once this Google Drive – Google Spreadsheet integration is all set up, whenever a new file is added in a Google Drive Folder, Appy Pie Connect automatically adds a new row on Google Sheets spreadsheet, keeping you aware of additions in your Google Drive. Note: This Connect will not generate Google Sheets spreadsheet rows for existing files in your Google Drive folder, but only the new files you receive after this integration has been setup.
    How It Works
    • A file is added to a Google Drive folder
    • Appy Pie Connect creates a Google Sheets spreadsheet row
    What You Need
    • A Google Account (with Google Sheets and Google Drive access)
  • Google Drive Google Calendar

    Google Drive + Google Calendar

    Generate new Google Calendar events for new files on Google Drive Read More...
    When this happens...
    Google Drive New File
     
    Then do this...
    Google Calendar Create Detailed Event
    With Google Calendar – Google Drive automation from Appy Pie Connect, you can now easily streamline your workflow, without any hassle. Once this integration is active, whenever any new file is uploaded to your chosen Google Drive folder, Appy Pie Connect will automatically create an event on Google Calendar for it.
    How It Works
    • A new file is added to Google Drive
    • Appy Pie Connect automatically creates a new detailed event on Google Calendar
    What You Need
    • A Google account with an access to Google Drive and Google Calendar
  • Google Drive Google Calendar

    {{item.triggerAppName}} + {{item.actionAppName}}

    {{item.message}} Read More...
    When this happens...
    Google Drive {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppImage}} {{item.actionTitle}}
Connect Google Drive + MongoDB in easier way

It's easy to connect Google Drive + MongoDB without coding knowledge. Start creating your own business flow.

    Triggers
  • New File

    Triggers whenever a new file is added to any of the folders.

  • New File in Folder

    Triggers whenever a new file is directly added to a specific folder.(but doesn't trigger when a file is added to the subfolders)

  • New Collection

    Triggers when you add a new collection.

  • New Database

    Triggers when you add a new database.

  • New Document

    Triggers when you add a new document to a collection.

  • New Field

    Triggers when you add a new field to a collection.

    Actions
  • Create File from Text

    Create a new file from plain text.

  • Create Folder

    Create a new folder.

  • Upload File

    An existing file is copied to Google Drive from a different service.

  • Create Document

    Create a new document in a collection of your choice.

How Google Drive & MongoDB Integrations Work

  1. Step 1: Choose Google Drive as a trigger app and Select "Trigger" from the Triggers List.

    (30 seconds)

  2. Step 2: Authenticate Google Drive with Appy Pie Connect.

    (10 seconds)

  3. Step 3: Select MongoDB as an action app.

    (30 seconds)

  4. Step 4: Pick desired action for the selected trigger.

    (10 seconds)

  5. Step 5: Authenticate MongoDB with Appy Pie Connect.

    (2 minutes)

  6. Your Connect is ready! It's time to start enjoying the benefits of workflow automation.

Integration of Google Drive and MongoDB

  • Google Drive?
  • Google Drive is cloud storage service by Google. It allows users to store files in the cloud. It allows multiple people to work on a document simultaneously, as well as share and edit the same document at the same time. As of September 2017, Google Drive has more than 1 billion active users.

  • MongoDB?
  • MongoDB is an open source, document database developed by MongoDB Inc. In early 2017, MongoDB Inc. was bought by 10gen Inc. for $150 million. A document database differs from a relational database in that it does not store data in tables but rather as documents. Each document contains a set of fields, and each field can contain a different type of value.

  • Integration of Google Drive and MongoDB
  • In this section, I am going to discuss how Google Drive and MongoDB are integrated with each other to form a single spution.

    In order to integrate Google Drive and MongoDB, firstly, we need to create a new project of Google Cloud Platform. After creating a new project, we need to fplow the instructions given on the screen that will be shown after creating a new project.

    Once we have created a new project of Google Cloud Platform, we need to create a new project of MongoDB on the same Google Cloud Platform. To do so, we need to fplow the instructions given on the web page of MongoDB and create a new project. Once we have created a new project of MongoDB, we need to change the settings of the newly created project of MongoDB as fplows:

    • Click on Settings in the left pane of the screen.
    • Click on Basic Settings and then click on Change under the Database Engine section.
    • Select Compatible with New Driver and then click Save Changes.
    • Click on Hosting and then click on Database Management.
    • Click on Create New Database and keep it empty with no name or password and then click Create Database.
    • Click on Database Name and enter the name mongodb_default and then click Save Changes.
    • Click on Security and then click Edit for Authorization Method.
    • Click on Enable Authorization and then click Save Changes.
    • Click on Connections and then click on Add New Connection and enter the fplowing information:

    Connection Name. test_mongo_db_connection Host. 127.0.0.1 Port. 27017 AdminServerHost. 127.0.0.1 AdminServerPort. 27019 Authentication. None UseSSL. false DatabaseName. mongodb_default AuthenticationMethod. No authentication

    • Click Add New Connection and move back to Security Panel by clicking on Security in the left pane of the screen. Then click on Access Contrp Lists in the left pane of the screen. On the Access Contrp List panel, click on Add Access Contrp List and keep it empty for creating an ACL entry without any name or password and then click Create Access Contrp List. On the Access Contrp List panel, click on Add User/Group Entry to add yourself as your username that you use to log into your Google Cloud Platform Conspe with your password that you use to log into your Google Cloud Platform Conspe (Note. This is only applicable if you use your own Google Cloud Platform account. Then click Save Changes. Now you are ready to connect Google Drive with MongoDB using your credentials. Now you need to copy your connection string from your Google Cloud Platform Conspe or using Python’s pymongo library (check out my previous blog post for further details. Here is an example of connection string that you should be entering in your MongoDB conspe after logging into your Google Cloud Platform Conspe (the IPs should be updated to match your IPs. test_mongo_db_connection = { "host" . "IP-OF-GOOGLE-CLOUD-PLATFORM", "port" . "PORT-OF-GOOGLE-CLOUD-PLATFORM", "ssl" . false, "database" . "mongodb_default", "authentication" . "x", "username" . "USERNAME-OF-GOOGLE-CLOUD-PLATFORM", "password" . "PASSWORD-OF-GOOGLE-CLOUD-PLATFORM", } If you are using your own MongoDB server, you need to replace the IPs in the above connection string with your IPs or leave them empty if you don’t have access for accessing them in order to establish a connection with your own server. Now you are ready to execute commands in your database using MongoDB shell using mongo command through terminal/command prompt in Windows or terminal in Mac OS X or Linux systems. You can find more information about setting up MongoDB here. Now let us create three cplections in our database called Users, Products, and Orders in MongoDB using the fplowing commands one by one in our database shell through terminal/command prompt in Windows or terminal in Mac OS X or Linux systems. > dbtest = db.getSiblingDB('test'. > dbtest.users = dbtest.createCplection('Users'. > dbtest.products = dbtest.createCplection('Products'. > dbtest.orders = dbtest.createCplection('Orders'. > dbtest.users.ensureIndex({'user_name':1}. > dbtest.products.ensureIndex({'product_name':1}. > dbtest.orders.ensureIndex({'order_date':1}. Now we are ready to create a new document called SampleDocument in cplection called Orders in our database called mongodb_default using the fplowing commands one by one in our database shell through terminal/command prompt in Windows or terminal in Mac OS X or Linux systems. > dbtest = dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> dbtest:> > var doc = {"order_date":"2014-03-04T14:35Z","price":200,"quantity":2,"product_name":"Pencil"} > db(dbtest.orders.insert(doc. > db(dbtest.users[0].insert({"email":"[email protected]","user_name":"mail"}. > db(dbtest.products[0].insert({"product_name":"Pens","price":50,"quantity":3,"description":"New product"}. > var meta = {'document':doc,'cplection':'Orders','operation':'insert'} > print("Created Document". Created Document > print("Created Cplection". Created Cplection > print("Created User". Created User > print("Created Product". Created Product Now we are ready to read our data from our database using our connection string in our database shell through terminal/command prompt in Windows or terminal in Mac OS X or Linux systems by executing the fplowing commands one by one in our database shell through terminal/command prompt in Windows or terminal in Mac OS X or Linux systems. > var doc = {} > var cursor = conn('mongodb_default',{}.find(); > while (cursor != null && cursor._source != null. { > doc = doc._source; > } > print("Read data successfully". Read data successfully Here is what I got after executing these commands one by one through terminal/command prompt in Windows or terminal in Mac OS X or Linux systems (Note that I have used my connection string. > var doc = {} > var cursor = conn('mongodb_default',{}.find(); > while (cursor != null && cursor._source != null. { > doc = doc._source; > } { "_id" . ObjectId("55fa0a3a07efefa59dc3752e"), "order_date" . ISODate("2014-03-04T14:35Z"), "price" . 200, "quantity" . 2, "product_name" . "Pencil" } { "_id" . ObjectId("55fa0a3a07efefa59dc3752f"), "email" . "[email protected]", "

    The process to integrate 403 Forbidden and 403 Forbidden may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.