How to Add Row in Google Sheets for New Google Drive Folder Using Pabbly Connect

Learn how to seamlessly add a new row in Google Sheets for every new folder created in Google Drive using Pabbly Connect. Follow our step-by-step tutorial!

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To add a row in Google Sheets for a new Google Drive folder, we will use Pabbly Connect. This integration allows seamless automation between Google Drive and Google Sheets. Start by signing into your Pabbly Connect account or create a new one if you are a first-time user.

Once logged in, navigate to the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button located in the upper right corner. Name your workflow something descriptive, like ‘Add New Row in Google Sheets for New Google Drive Folder.’ Choose a relevant folder for organization, such as ‘Google Drive Google Sheets Automation,’ and click on ‘Create’ to proceed.

2. Defining Trigger and Action in Pabbly Connect

In Pabbly Connect, the next step is to define the trigger and action for your workflow. For this integration, the trigger application will be Google Drive, and the action application will be Google Sheets. In the trigger section, search for Google Drive and select it.

• Select the trigger event as ‘New Folder’ to initiate the workflow whenever a new folder is created.
• In the action section, search for Google Sheets and select it.
• Choose the action event as ‘Add New Row’ to insert folder details into Google Sheets.

After selecting the trigger and action, you will need to establish a connection between Google Drive and Pabbly Connect. Click on ‘Connect’ next to Google Drive and authorize the connection by signing in with your Google account.

3. Creating a New Folder in Google Drive

With the connection established, it’s time to create a new folder in Google Drive. This action will trigger the automation set up in Pabbly Connect. Go to your Google Drive and create a new folder, for instance, name it ‘Facebook Leads Details.’ This folder will be used to test the integration.

Once the folder is created, return to Pabbly Connect and click on ‘Save and Send Test Request.’ This action will fetch the details of the newly created folder, including its name, link, and creation date. Ensure that the trigger is polling for new data every 10 minutes to capture updates in real-time.

4. Mapping Folder Details to Google Sheets

Now that you have the folder details fetched in Pabbly Connect, the next step is to map these details into Google Sheets. First, connect to Google Sheets using the existing connection you set up earlier. Select the correct spreadsheet where you want to add the folder details.

• Map the folder name to the corresponding column in Google Sheets.
• Map the folder link to another column.
• To fetch the creation date, use the text formatter to split the date and time, mapping only the date to the final column.

After mapping all the necessary fields, click on ‘Save and Send Test Request’ to confirm that the details are correctly added to the new row in your Google Sheets.

5. Verifying the Integration in Google Sheets

After successfully saving the test request, navigate to your Google Sheets to verify that the folder details have been added correctly. You should see the new row populated with the folder name, link, and creation date. This confirms that the integration through Pabbly Connect is functioning as intended.

Now, every time a new folder is created in Google Drive, the details will automatically be added to your Google Sheets. This automation saves time and ensures accurate record-keeping without manual input.

Conclusion

Using Pabbly Connect, you can efficiently automate the process of adding a new row in Google Sheets for every new Google Drive folder. This integration not only streamlines your workflow but also enhances productivity by reducing manual tasks.