How to Sync Google Drive Files to Google Sheets in Real Time

Learn how to sync Google Drive files to Google Sheets in real time with Pabbly Connect. Follow this detailed tutorial 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. Accessing Pabbly Connect for Integration

To sync Google Drive files to Google Sheets in real time, start by accessing Pabbly Connect. Open your browser and type in Pabbly.com/n to reach the homepage.

Once there, you will see two options: ‘Sign In’ for existing users and ‘Sign Up Free’ for new users. If you are new, click on ‘Sign Up Free’ to get 100 free tasks each month. Existing users can simply sign in.

2. Creating a New Workflow in Pabbly Connect

After signing in, navigate to your dashboard and click on the ‘Create Workflow’ button. This is essential for setting up the automation to sync files. using Pabbly Connect

In the workflow creation dialog, name your workflow, for example, ‘Sync Google Drive Files to Google Sheets in Real Time.’ Choose the folder from which you want to sync files. Here’s how to do it:

• Click on the dropdown menu to select your desired folder.
• Ensure the folder is set correctly to capture the new files.

Click on the ‘Create’ button to finalize your workflow setup. Now you are ready to set up the trigger for your automation.

3. Setting Up the Trigger with Google Drive

For this integration, the trigger will be Google Drive. Select ‘Google Drive’ as your trigger application and choose the event as ‘New File in a Specific Folder.’ This will allow Pabbly Connect to monitor the folder for new uploads.

Next, click on ‘Connect’ to establish a connection with your Google Drive account. If prompted, sign in with your Google account and grant Pabbly Connect the necessary permissions to access your files.

After successful connection, specify the folder you want to monitor for new files. You can do this by either selecting it from the dropdown or by mapping the folder ID. To map the folder ID:

• Copy the folder ID from your Google Drive URL.
• Paste it into the designated field in Pabbly Connect.

Once done, click on ‘Save and Send Test Request’ to ensure everything is working correctly. This step checks if Pabbly Connect can access the new file details.

4. Setting Up the Action with Google Sheets

Now that you have set up the trigger, it’s time to define the action that will occur in Google Sheets. Choose ‘Google Sheets’ as your action application and select ‘Add a New Row’ as the action event.

As before, click on ‘Connect’ to link your Google Sheets account with Pabbly Connect. After signing in, grant the necessary permissions.

Once connected, select the spreadsheet and sheet where you want to add the new row. Map the data fields from the trigger step to the action step:

Map the file name to the corresponding column in your Google Sheet. Map the file URL to another column. Add any additional details as needed.

After mapping the fields, click on ‘Save and Send Test Request’ to confirm that the data is correctly sent to Google Sheets. You should see a new row added with the file details.

5. Finalizing the Integration and Testing

With the workflow set up, it’s time to finalize the integration. Ensure your Google Drive folder is set to be shareable with anyone who has the link. This allows your team members to access the uploaded files easily.

To make the folder shareable, right-click on the folder in Google Drive, select ‘Share,’ and adjust the settings to allow access to anyone with the link.

After making the folder shareable, upload a new file to the specified Google Drive folder. This will trigger the automation set up in Pabbly Connect. Check your Google Sheets to see if a new row has been added with the file details. This confirms that your integration is working seamlessly.

Conclusion

By following these steps, you can effectively sync Google Drive files to Google Sheets in real time using Pabbly Connect. This automation saves time and enhances team collaboration by instantly updating file details in your spreadsheets.