How to Create Google Drive Folder for New Airtable Record Using Pabbly Connect

Learn how to create a Google Drive folder for new Airtable records using Pabbly Connect. This detailed tutorial covers every step of the integration process.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To create a Google Drive folder for each new Airtable record, you need to access Pabbly Connect. Start by opening a web browser and navigating to the Pabbly Connect website. If you don’t have an account, you can sign up for free and get 100 tasks every month.

Once logged in, click on the ‘Access Now’ button under Pabbly Connect to reach the dashboard. Here, you can create workflows that automate your tasks. This is where you will set up the integration between Airtable and Google Drive.

2. Creating a New Workflow in Pabbly Connect

To begin, click on the ‘Create Workflow’ button in your Pabbly Connect dashboard. This will prompt you to name your workflow. Choose a name that reflects your objective, such as ‘Create Google Drive Folder for New Airtable Record’. Next, select the folder where you want to save this workflow.

• Click on ‘Create’ to start your workflow.
• You will see two boxes: Trigger and Action.

In this setup, the Trigger application will be Airtable, and the Action application will be Google Drive. This allows you to automate the process of creating folders based on new records in Airtable.

3. Setting Up the Trigger with Airtable

In the Trigger section of Pabbly Connect, select Airtable as your application. For the trigger event, choose ‘New Record’. This means that every time a new record is created in Airtable, it will trigger the workflow.

Next, you will need to connect your Airtable account to Pabbly Connect. Click on ‘Connect’, then ‘Add New Connection’. You will be prompted to select the base you want to use. Choose your base, such as ‘Employee Details’, and grant access. This connection will allow Pabbly Connect to access your Airtable data.

4. Creating a Google Drive Folder Automatically

After setting up the trigger, you will now set the Action application to Google Drive in Pabbly Connect. Choose the action event ‘Create Sub Folder’. This action will create a new folder in Google Drive whenever a new record is added in Airtable.

To connect Google Drive, click on ‘Connect’ and sign in with your Google account. Make sure to allow access. Then, select the folder where you want to create the new sub folders, such as ‘New Employees’. You will map the employee name from Airtable to the subfolder name in Google Drive.

• Use the mapping feature to pull the employee’s name from the Airtable record.
• Click ‘Save and Send Test Request’ to create the folder.

Once this is done, check your Google Drive to see if the new folder has been created successfully. This confirms that the integration is working properly.

5. Updating Airtable with the Google Drive Folder URL

Finally, you need to update the Airtable record with the URL of the newly created Google Drive folder. In Pabbly Connect, add another action and select Airtable again. Choose the action event ‘Update Record’. This will allow you to update the existing record with the folder URL.

Map the record ID and the folder URL in the fields provided. For the folder URL, copy the base URL and append the folder ID that was generated when creating the folder. Once everything is mapped correctly, click on ‘Save and Send Test Request’. This will update the Airtable record with the folder URL.

Conclusion

Using Pabbly Connect, you can efficiently create a Google Drive folder for every new Airtable record and automatically update the record with the folder URL. This integration streamlines your workflow and saves time, making it easier to manage employee records.