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

Learn how to automate the creation of Google Drive folders for new Airtable records using Pabbly Connect, enhancing your workflow efficiency. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To create a Google Drive folder for new Airtable records, you will first need to access Pabbly Connect. This platform allows for seamless integration between different applications without any coding skills. Simply open a new tab in your browser and search for Pabbly Connect.

If you are new to Pabbly Connect, you can sign up for a free account, which takes only a couple of minutes. Once signed in, navigate to the dashboard where you can create workflows.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button and name your workflow, such as ‘Create Google Drive Folder for New Airtable Record’. Next, select the folder where you want to save this workflow.

• Click on the ‘Create’ button after selecting the folder.
• You will see two boxes: Trigger and Action.
• Set up the Trigger application as Airtable.

After setting up the Trigger, you’ll need to define the trigger event as ‘New Record’. This allows Pabbly Connect to react whenever a new record is created in Airtable.

3. Connecting Airtable to Pabbly Connect

To establish a connection between Airtable and Pabbly Connect, click on ‘Connect’ and select ‘Add New Connection’. Once you log in to your Airtable account, choose the base that contains your employee details.

Make sure to select the correct table where new records will be created. For this integration, it is essential to have a column named ‘Created’ with the field type set to ‘Created Time’. This setup is crucial for receiving record details from Airtable.

4. Setting Up Google Drive in Pabbly Connect

Now, you will set up the action step to create a folder in Google Drive using Pabbly Connect. Select Google Drive as the action application and choose ‘Create Sub Folder’ as the action event. You will then need to connect Google Drive to Pabbly Connect by clicking on ‘Connect’ and allowing access to your Google account.

• Select the folder where you want to create the new sub-folder.
• Map the employee name from the Airtable record to the sub-folder name.
• Click on ‘Save and Send Test Request’ to create the folder.

Once you receive a positive response, you can verify the folder’s creation in Google Drive under the specified folder. This confirms that the integration is working correctly through Pabbly Connect.

5. Updating Airtable with Google Drive Folder URL

The final step is to update your Airtable record with the URL of the newly created Google Drive folder using Pabbly Connect. Set up another action step with Airtable and select ‘Update Record’ as the action event. Use the existing connection to Airtable that you created earlier.

You will map the record ID from the previous steps and update the folder URL field. This involves copying the base URL of the Google Drive folder and appending the folder ID that was returned when the folder was created.

After clicking ‘Save and Test Request’, you should see a positive response indicating that the record has been updated successfully. You can verify this by checking your Airtable record to see the updated folder URL.

Conclusion

By following these steps, you can successfully automate the creation of Google Drive folders for new Airtable records using Pabbly Connect. This integration enhances your workflow efficiency, allowing for organized document management with minimal effort.