My goal is to Post Instagram Image (via URL in Google Sheet) to Pinterest for that …hence used below sequence
-
Google Sheets → Search Rows
Pulls new rows with Instagram URLs.
Filter only rows that haven’t been processed (e.g., a column “Posted” is empty). -
Tools → Set Variable
Variable name: post_url
Value: Instagram URL column from Google Sheet (e.g., Row[InstagramURL])
3.HTTP → Make a Request
URL: https://www.instagram.com/oembed/?url={{2.post_url}}
Method: GET
No headers or body needed.
Idea was that this will return JSON with the image URL in .thumbnail_url
4.JSON → Parse JSON
JSON String: 4.data
Click: “Create data structure”
Paste this sample output from Instagram oEmbed API:
{
“author_name”: “nailartpage”,
“thumbnail_url”: “https://instagram.xx.fbcdn.net/v/t51.2885-15/e35/123456789_n.jpg?_nc_ht=…”,
“title”: “Some beautiful nail art design”
}
It should create a field thumbnail_url.
- Pinterest → Create a Pin
Board ID: Used Pinterest board ID (click into the board).
Image URL: 5.thumbnail_url
Title: 5.titl e.g. “Top Nail Art Design”
Source URL: 2.post_url (linking back to original IG post)
6.Google Sheets → Update Row
Update the same row from step 1.
Set “Posted” column to Yes to prevent duplicate posting.
But got error in Stage 4 Parse JSON as Source is not valid JSON.
Can someone help me what steps needs to be done or any alternative is there to get this resolved…I guess Instagram oEmbed API is not right solution
Integration Google Sheets, Tools, HTTP, JSON, Pinterest.blueprint.json (42.7 KB)
