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

Learn how to add a new row in Google Sheets for a new Google Drive folder using Pabbly Connect. Follow this step-by-step tutorial for seamless integration.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin adding a new row in Google Sheets for a new Google Drive folder, you first need to access Pabbly Connect. This powerful integration platform allows you to automate tasks between Google Drive and Google Sheets seamlessly.

As an existing user, you can sign in to your Pabbly Connect account. If you are new, click on the ‘Sign Up for Free’ button. You can utilize 100 free tasks every month, making it easy to get started with your automation.

2. Creating a Workflow in Pabbly Connect

Once signed in, navigate to the dashboard of Pabbly Connect. Click on the ‘Create Workflow’ button located in the right corner. You will be prompted to name your workflow; for this tutorial, name it ‘Add New Row in Google Sheets for New Google Drive Folder’.

• Select a folder to save this workflow, such as ‘Google Drive Google Sheets Automation’.
• Click on ‘Create’ to proceed to the next step.

After creating the workflow, you will encounter a window where you can set up the trigger and action. This is crucial as it will dictate how Pabbly Connect operates between Google Drive and Google Sheets.

3. Setting Up Trigger and Action in Pabbly Connect

In the trigger section, search for ‘Google Drive’ as your trigger application. The trigger event will be set to ‘New Folder’. This means every time a new folder is created in Google Drive, the workflow will initiate. using Pabbly Connect

Next, move to the action section and select ‘Google Sheets’ as your action application. Here, the action event should be set to ‘Add New Row’. This setup ensures that whenever a new folder is created in Google Drive, the details will be automatically added to a new row in Google Sheets.

4. Connecting Google Drive and Google Sheets in Pabbly Connect

To establish a connection between Google Drive and Pabbly Connect, click on the ‘Connect’ button. You will need to sign in with your Google account and grant access. Once authorized, you will see a confirmation of successful connection.

Next, you will need to select the specific Google Sheet where you want to add the folder details. Choose the sheet named ‘Google Drive Folders’ which contains columns for folder name, folder link, and created date.

• Map the folder name from Google Drive to the corresponding column in Google Sheets.
• Map the folder link and the created date similarly.

This mapping process is essential as it allows Pabbly Connect to dynamically insert data from Google Drive into Google Sheets, ensuring that each new folder’s details are recorded properly.

5. Testing the Integration and Finalizing Setup

After mapping the fields, click on ‘Save and Send Test Request’ in Pabbly Connect. This action will create a test entry in your Google Sheets based on the newly created folder in Google Drive.

Verify that the new row appears in your Google Sheets with the correct folder name, link, and created date. If everything looks good, your integration is successfully set up!

Now, every time you create a new folder in Google Drive, the details will automatically populate in a new row in Google Sheets, thanks to Pabbly Connect. This automation saves time and ensures that your folder details are always up to date.

Conclusion

In this tutorial, we demonstrated how to add a new row in Google Sheets for a new Google Drive folder using Pabbly Connect. By following these steps, you can automate your workflow efficiently and keep your data organized effortlessly.