Before we begin, it's important to note that SocialScrape is a web scraping tool that allows users to extract data from various social media platforms, including Instagram, TikTok, and Twitter. Zapier, on the other hand, is an automation tool that allows users to connect apps and automate workflows between them. By integrating SocialScrape with Zapier, users can automate the process of scraping data from social media platforms and storing it in a Google Sheet.
To get started, you'll need to have a SocialScrape API key and a Zapier account. If you don't have these yet, you can sign up for a SocialScrape here, buy a subscription and generate an API key from the dashboard. To create a Zapier account visit the Zapier website here.
Step 1: Create a new Zap
The first step is to create a new Zap in Zapier. To do this, log in to your Zapier account and click on the "Make a Zap" button in the top right corner of the screen. You can also find our Zapier integration page here
Step 2: Choose SocialScrape as the trigger app
Next, you'll need to choose Google Sheets as the trigger app. To do this, search for Google Sheets in the app search bar and select it from the dropdown menu.
Step 3: Set up the trigger event
Once you've selected Google Sheets as the trigger app, you'll need to set up the trigger event. You'll find some sample input and output Google sheets here for this purpose.
You'll need to select your Google Sheet from the UI and then select the "New Spreadsheet Row" event. Connect and select your Google account as well. The input spreadsheet should have its query parameter names as rows. Once you've selected the input sheet, you'll need to select its worksheet number as well.
Step 4: Test the trigger
Now that you've set up the trigger, you can test it by pulling up the data from the Google Sheet, it should pull latest row from the spreadsheet which will then be mapped to the action.
Step 5: Set up the action
The next step is to set up the action that will scrape the data from the desired endpoint. To do this, you'll need to choose the "SocialScrape" from the actions field. Then select the "Scrape Instagram Posts" event from the dropdown menu.
Enter your SocialScrape API key when prompted. Then, you'll be presented with a screen where you can map the columns with corresponding data fields on the action. For example, map username with username, etc.
After you've mapped the fields, you can test the action by scraping data from the SocialScrape API.
Step 6: Set up the output sheet
The next step is to set up the output sheet, which will contain the scraped data. For this step, you'll need to choose the "Create Spreadsheet Row" event from the output app dropdown menu.
Select your Google account and then select the spreadsheet where you want to store the scraped data. You can also provide a sample output Google sheet to help with this process. The sheet should contain different columns for all the outputs provided by the specific endpoint.
Here, you'll need to map the fields again, but this time there will be lots of fields shown to you in action. Click on "Count" and select "Count" in the dropdown as well.
Step 7: Test the output sheet
After mapping the fields, you can continue and test the output sheet by creating multiple rows of scraped
That's all, you now should be set up right to start scraping Instagram, TikTok or Twitter data using our official Zapier connection! We hope you found it useful. If you're missing anything, please let us know on firstname.lastname@example.org