Google Spreadsheets (not Excel) =ImportXML function + Xpath: Scrape [login to view URL]


I am looking for Google Spreadsheet webscrape solution for this spreadsheet:

[login to view URL]

Example link in cell A1:


Click the link in A1, click the "Share" button, click the "Embed" tab. There you will see the code:

<iframe width="100%" height="450" scrolling="no" frameborder="no" src="[login to view URL];auto_play=false&amp;hide_related=false&amp;show_comments=true&amp;show_user=true&amp;show_reposts=false&amp;visual=true"></iframe>

In B1, use the =ImportXML and an XPath to pull the above code. This should work on any Soundcloud link like the one in A1.

When you bid please end your bid with the number one. For example, instead of bidding ten dollars, bid eleven instead. This will prove to me that you can read directions carefully. Also, please start your message to me with "Dear Douglas." This will further prove to me that you can read directions carefully.

Please do not solve by copying and pasting the link, this must be solved by formula. Also, this must be Google Documents, not Excel. Good luck!

Example link in cell A1:

Beceriler: Excel, Google Web Toolkit, Python, XML

Daha fazlasını gör: python button, google spreadsheet example, google documents, google-docs.com, google docs.com, docs google com, docs. google

İşveren Hakkında:
( 65 değerlendirme ) Timonium, United States

Proje NO: #9221801



Dear Douglas, I have written a formula to accomplish the task. I have tested it and it works perfectly fine. Please award me the project so I can give you the formula right away. Thank you & best regards, Oshan Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(7 Değerlendirme)

Bu iş için 6 freelancer ortalamada $98 teklif veriyor


Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$250 USD in 5 gün içinde
(146 Değerlendirme)

Hi, I am Anna. I have read through your project description. I will write a function for B1 and C1 when you insert the A1 data in google spreadsheet. My budget is $35 (because freelancer fee is $5, I will get on Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(32 Değerlendirme)

Hi, I am a student who is good at coding in python. This can be done using selenium for opening the url and can be clicked share and copy the embed code and put to spreadsheet villa pysheet library in python.I have alr Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)

Dear Douglas, I have great knowledge on Advanced Excel and Office tools. I have been working with MNC since last 8 years on same domain. I will be beneficial for your projects as I always put my best for client sat Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

Предложение еще не подано

$222 USD in 5 gün içinde
(0 Değerlendirme)