How to Save Specific Google Drive File Links to Google Sheets Using Pabbly Connect

Learn how to automate saving specific Google Drive file links to Google Sheets using Pabbly Connect. Step-by-step guide for seamless integration. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Drive and Google Sheets Integration

To save specific Google Drive file links to Google Sheets, you need to use Pabbly Connect. Begin by logging into your Pabbly Connect account. Once logged in, click on the ‘Create Workflow’ button to start a new integration process.

Next, name your workflow and click on the create button. You will be directed to a workflow page where you will find two modules: the trigger and the action. The trigger will be set up to detect new files uploaded in a specific Google Drive folder.

2. Configuring Google Drive as the Trigger Application

In this step, select Google Drive as your trigger application in Pabbly Connect. Choose the trigger event as ‘New File in Specific Folder’. Click on the connect button and select ‘Add New Connection’.

Sign in with your Google account that has access to the Google Drive folder where you will upload files. After authorization, select the specific folder (e.g., ‘Team Files’) where you will be uploading Excel files. Once selected, click on ‘Save and Send Test Request’ to verify the connection.

• Select Google Drive as the application.
• Choose ‘New File in Specific Folder’ as the trigger event.
• Connect your Google account.
• Select the folder where files will be uploaded.

After the test request, you will receive a response showing the last uploaded file details, including its link and title, which is essential for the next steps in your automation.

3. Applying Filters to Ensure Specific File Types Are Saved

To ensure only specific file types (like Excel files) are saved to Google Sheets, you will use a filter step in Pabbly Connect. Add a filter by selecting the ‘Filter by Pabbly’ option. Set the filter condition to check if the file extension is equal to ‘xlsx’.

Map the file extension from the previous step into the filter condition. Click on ‘Save and Send Test Request’ to check if the condition is true. If the condition is met, the workflow will proceed to the next step, allowing the data to be sent to Google Sheets.

• Select ‘Filter by Pabbly’ as the action step.
• Set the condition to check file extension.
• Map the file extension from the trigger step.
• Test the filter condition.

Once the filter is successfully validated, you are ready to send the data to Google Sheets.

4. Sending Data to Google Sheets Using Pabbly Connect

In this step, select Google Sheets as the action application in Pabbly Connect. Choose the action event as ‘Add New Row’. Click on the connect button and select ‘Add New Connection’ to connect your Google account again.

After connecting, select the spreadsheet (e.g., ‘Google Drive Files’) where you want the data to be stored. Map the file name and file link fields to the corresponding headers in your Google Sheet. Ensure that you map the correct values from the previous steps.

Select Google Sheets as the action application. Choose ‘Add New Row’ as the action event. Map the file name and file link to the spreadsheet columns. Test the action to ensure data is added correctly.

After testing, you should see a new row added in Google Sheets with the file name and the downloadable link.

5. Conclusion: Automate Your Google Drive to Google Sheets Workflow

By using Pabbly Connect, you can automate the process of saving specific Google Drive file links to Google Sheets effortlessly. This integration allows you to save time by eliminating manual data entry, ensuring that every time you upload an Excel file, its details are automatically stored in your designated Google Sheet.

Now you can easily manage your files and links in one place without any hassle. Set up this automation once, and it will work seamlessly every time you upload a new file.

With Pabbly Connect, integrating various applications becomes a breeze, enabling you to focus on more important tasks while the automation takes care of the data management.