Save Instagram Profile Stats to Google Sheets (n8n + Apify)

Save Public Instagram Profile Stats to Google Sheets (n8n + Apify)

Need to quickly collect public Instagram profile details for a list of accounts? This n8n workflow fetches each profile using Apify’s bakos_bence/instagram-profile-scraper actor and appends the key stats (name, bio, follower counts, links) into your Google Sheets—on demand.

What this workflow does

• Runs manually: you trigger the workflow whenever you need fresh profile data.
• Uses an Instagram username list: edit the input step with the handles you want to look up.
• Calls the Apify API: the workflow starts the Apify actor bakos_bence/instagram-profile-scraper and retrieves profile results for the provided usernames.
• Validates responses: it checks for a valid profile ID and skips empty/invalid results.
• Extracts & flattens fields: writes a consistent set of columns including username, full name, biography, followersCount, followsCount, postsCount, externalUrl, and inputUrl.
• Appends rows to Google Sheets: each profile becomes a new worksheet row via the Google Sheets node.

Use cases

• Build a lightweight Instagram lead database by capturing follower/following/post counts.
• Monitor social proof for creators/brands by periodically re-checking profiles.
• Populate a spreadsheet for outreach workflows without manual copy/paste.
• Support SaaS ops and analytics teams with a repeatable Instagram to Google Sheets pipeline.

Technical details

• Apify API via HTTP Request using an auth header: Authorization: Bearer <YOUR_APIFY_TOKEN>
• Google Sheets OAuth2 credential for appending rows
• Target worksheet header columns (recommended): username, fullName, biography, followersCount, followsCount, postsCount, externalUrl, inputUrl
• Workflow logic includes validation/conditional handling (if) and data preparation (set)

Setup checklist

Create an Apify token, add the Bearer authorization header credential, configure the Google Sheets OAuth2 credential, set your spreadsheet/worksheet, and update the username list in the input step.