/docs/community?hl=en
/docs/community?hl=en
3/10/16
Original Poster
MridulR

google sheet importxml login access

Hi,

I've used importxml to get public info from a website. But sometimes info changed when we access though different country. For example http://www.ebay.com/itm/221998403138?_trksid=p2057872.m2749.l2649&var=520870142881

this item is not available in USA but when we'll access from different country where seller shipped or changed the country of shipping, we can find the shipping cost. If I use importxml from google sheet, that means the access country will be USA. How far I understand i can't change the IP of google sheet. So I would like to know if is there any way to sent login detail though url. That means I want to specific google sheet to access url though my login details(username and password).

So that shipping cost will appear under xpath.

//*[@id="fshippingCost"]/span[1] -- Non-US country where seller ship

//*[@id="shSummary"]/span[1] - USA, shipping is not available

Please see the image for clarification.

http://prntscr.com/ad6fqi


Here is a sample sheet 


https://docs.google.com/spreadsheets/d/1Vm6xHvcxRjUl-qvN9U6WYx45gSAEyobsycBniFU25U8/edit#gid=0


Thanks in Advanced

Community content may not be verified or up-to-date. Learn more.
All Replies (1)
+Samantha
3/10/16
+Samantha
Hey there,

Thank you for taking the time to post your question to the Google Docs Help Forum.

My example may not be complete, because I was not sure if the Ebay URL changed when accessed from outside of the US, but it might demonstrate a workaround for you:


IFERROR() tests a second parameter if the first one returns an error. This allows you to test the two different options. Additionally, you can use an IF() statement and test to see if the first IMPORTXML() formula is "USA, shipping is not available" and if it is, to run the second IMPORTXML().


For others members or myself to better assist you, please consider sharing your spreadsheet or a sample sheet with realistic looking data. It might also help to show your expected results and explain why those results would be correct so that we may better understand your question.


Follow these steps to provide a shareable link:


  1. Open the file you want to get a link for.

  2. Click Share for files in the top-right corner of the screen Share.

  3. Click Get shareable link in the top-right corner of the sharing box. A link to the file will be copied to your clipboard.

  4. Paste the link into the forum to share it.


Best of luck,
Samantha
Was this reply helpful?
How can we improve it?
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Google Employee — Google product team members and community managers
 
Community Specialist — Google partners who help ensure the quality of community content
 
Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts
 
Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions
 
Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions
 
Product Expert Alumni — Former Product Experts who are no longer members of the program
Community content may not be verified or up-to-date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.

false
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false