How to Add Instagram Post Details to Google Sheets Using Pabbly Connect

Learn to integrate Instagram with Google Sheets using Pabbly Connect to automate post detail tracking effortlessly. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To begin integrating Instagram with Google Sheets, the first step is to access Pabbly Connect. Open your web browser and type the URL Pabbly.com/connect. This will take you to the Pabbly Connect landing page.

If you already have an account, you can simply sign in. If you are a new user, click on the ‘Sign Up for Free’ tab. After creating your account, you will receive 100 free tasks to start your automation journey.

2. Create a New Workflow in Pabbly Connect

After signing in to Pabbly Connect, you will reach the applications dashboard. Here, click on the ‘Create Workflow’ button. A dialog box will appear asking you to name your workflow. Name it ‘Add Instagram Post Details to Google Sheets’ and click on ‘Create’.

This will lead you to a new window with two crucial events: Trigger and Action. In this case, your trigger application will be Instagram for Business, and the action application will be Google Sheets. This setup is essential for automating the process of adding Instagram post details to your Google Sheets.

3. Set Up Instagram Trigger in Pabbly Connect

Now, within your workflow, select Instagram for Business as the trigger application. Choose the event ‘New Media Posted’. This trigger checks for new data every 10 minutes, allowing you to capture Instagram posts automatically.

Click on ‘Connect’ to link your Instagram for Business account with Pabbly Connect. If prompted, click on ‘Add New Connection’ and authorize the connection. Once connected, select your Instagram account from the dropdown menu and click on ‘Save and Send Test Request’. You should receive a response containing your latest Instagram post details, including the username, media type, and caption.

4. Format Date with Pabbly Connect’s Date Time Formatter

To ensure that the date is in the correct format for Google Sheets, you will need to add another application, which is the Date Time Formatter by Pabbly Connect. Choose the action event ‘Format Date with Time Zone’. Click on ‘Connect’ to proceed.

• Map the date from the previous Instagram trigger.
• Select the desired date format (e.g., simple date format).
• Click on ‘Save and Send Test Request’ to confirm the formatting.

Once formatted, your workflow will be ready to send the post details to Google Sheets seamlessly.

5. Add Instagram Post Details to Google Sheets

The final step is to add the formatted Instagram post details to Google Sheets. Select Google Sheets as the action application and choose the event ‘Add New Row’. Click on ‘Connect’ and authorize the connection with your Google Sheets account. using Pabbly Connect

Next, you will need to map the data fields from the previous steps into your Google Sheets. Select the spreadsheet you created for Instagram post details and map the following fields: username, caption, formatted date, media URL, and permalink. Click on ‘Save and Send Test Request’ to send the data to Google Sheets.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to integrate Instagram with Google Sheets, allowing you to automate the tracking of your Instagram posts. By following these steps, you can efficiently manage your Instagram feed and keep your data organized.