FalconScrape for Google Sheets™

Flipkart to Google Sheets

Search Flipkart India from Google Sheets and return product titles, prices, MRP, discounts and ratings. Use a search phrase or Flipkart search URL.

=FLIPKART_SEARCH("running shoes", 1, "limit=5")

Install and activate the add-on from Extensions → FalconScrape → Activate / Account. Enter the formula in an empty area; results expand down and right with a header row. Cell references such as A2 must contain a valid input.

More examples

• =FLIPKART_SEARCH("running shoes", 2, "limit=5")
• =FLIPKART_PRODUCT(A2)

Columns

Search costs 1 credit per returned row. One upstream page has up to 24 products; use the page argument for more. FLIPKART_PRODUCT costs 2 credits and adds brand, color, highlights and description. Put a product URL in A2 and run the detail example in an empty area or another sheet. See plans and credits.

Refresh results

Run Extensions → FalconScrape → Refresh all once to create the FALCON_REFRESH named range. Then use this version of the formula:

=FLIPKART_SEARCH("running shoes", 1, "limit=5", FALCON_REFRESH)

Refresh all updates the marker. Formulas referencing a marker less than 60 seconds old request fresh results, which consume credits when successful. Formulas without the reference are unaffected. Normal cache hits cost nothing; there is no scheduled refresh or automatic price-history log.

FAQ

Which Flipkart market does this cover?

Flipkart India. Check the returned currency alongside the price; available fields depend on the public product listing.

Can I pass a URL instead of a phrase?

Yes. FLIPKART_SEARCH accepts a Flipkart search/category URL. FLIPKART_PRODUCT accepts a full product URL from the search result's url column.

Can I limit the first test?

Use limit=5 to request at most five rows. The options argument supports limit; use the separate page argument to move to another result page.

What if a product lookup times out?

Product pages can be slow. Retry a single product after a short pause rather than filling a column with retries. Failed requests do not consume credits.