Skip to main content

All Questions

4 votes
1 answer
12k views

VALUE parameter cannot be parsed to number (Google SpreadSheet Error)

I`m trying to extract from this url: https://www.instagram.com/fcbarcelona/ the value of posts amount, this one: http://prntscr.com/p29wqn using this formula in google spreadsheet: =VALUE(...
1 vote
1 answer
412 views

Google Spreadsheets ImportXML / XPath - Image broken output

I am trying to scrape an image of my website via the ImportXML function in Google Sheets using XPath. The function seems to work, however the output seems to be broken. Instead of getting the URL of ...
0 votes
2 answers
909 views

Parsing Socialblade Information using Xpath and importing it into Google Sheets

I am trying to build a Youtube analysis template to monitor my channel's competition. I would like to parse certain information from Socialblade, but I have just managed to get the information which ...
0 votes
1 answer
1k views

Booking.com xpath

I'am trying to add "Hotel name" and "Price" to Excel. Via google spreadsheet which has function =importXML where one can add URL and Xpath to data. The problem is that xpath is not correct for prices ...