Hello, in Google Spreadsheets there is a useful function called “ImportXML” does exactly as it suggests. However, if the XML output contains a namespace attribute (xmlns=), it fails. This seems to be a known but unaddressed issue.

Not being a coder, I have searched high and low for a simple Google Apps script that can reliably replace this functionality but patching code snippets together has proven fruitless.

Here is a sample of the XML that I am attempting to parse: http://pastebin.com/2WdedJkT

Thanks in advance for any assistance.

Hello sir,

I just want to know that what will be the taxes will i have to pay in india,Currently i am doing affiliate marketing of foreign individual products through their website and they pay me via paypal,see when i call paypal they said me that “You dont have to pay any taxes on paypal,They said that they will charge only their fees(transaction fees and currency conversion fees)”,therefore here paypal point is clear,but when the amount is deposited then that time which taxes bank will charge on me like Service tax,vat?i know Income tax is compulsory,But do i have to pay service tax?

Waiting for reply

Hi, thank you so much for providing this script. I do not know anything about scripts or HTML or Java or anything, so I copied and pasted the script into my Google Drive exactly as the instructions said from this webpage:


But now when I go to click on the link for the web form, it brings me to the Google Accounts log in page. I am confused because you wrote “You don’t even need to have a Google Account to upload files and the Google Script based form even works on mobile devices.”. I would like people to be able to upload files to my Google Drive without having to log on to their Google account. How do I do that?

Hi Expert,

I hope you are doing well.

I have a query like, I went offline after 7:30PM India time and come online back by next day morning 10AM and whole weekend from Saturday and Sunday.

I am looking for the fix like I can configure schedule to active auto reply to the senders while particulate time frame.

The Gmail “vacation responder” has limitation and only work with date range and send auto reply once in a 4days to the same sender.

It would be a great help if you can suggest something in this matter.
Thanks for your concern.

Best regards,

I got the mail merge excel template… uploaded an attachment on google drive, double clicked on it… but not sure how to determine attachment id to be used for the template

Hi amit.. can u tell us the exact Ping url you use in wordpress. By default there is pingomatic. and also i am curious to know that do you ping your sitemap also to google and bing after every blog post.

thanks in advance.

I purchased Premium, but every time I click Mail Merge on your special spread sheet, I am encouraged to buy it.

Does this mean that my purchase is not recognized or is it just annoying?

I added the script and it works good. But I am having a couple issues.

1. When submitted it and received the email at the bottom of the email it shows some uneeded information. I have included my email info below. At the end you will see the “:: One Day Forgotten Chromebook Loan,,,,” that I would like removed. Any thoughts?

Timestamp :: 11/10/2014 10:48:14

Username :: email@kimberly.k12.wi.us

:: One Day Forgotten Chromebook Loan,,,,

TLC/Homeroom Teacher: :: Mrs. Behnke

Student Asset Tag Number: :: 2014-11683

Student Charger Asset Tag Number: :: N/A

Loaner Asset Tag Number: :: N/A

Please State Problem: :: Broken Hinge
Broken Screen
Broken Power

:: One Day Forgotten Chromebook Loan,,,,

:: One Day Forgotten Chromebook Loan,,,,

:: One Day Forgotten Chromebook Loan,,,,

:: One Day Forgotten Chromebook Loan,,,,

2. I see in the script it says….
// You may replace this with another email address
var email = Session.getActiveUser().getEmail();

And I would like it to send it to a different email but not sure how to put the email in there. Any thoughts on this?

Thanks for all the help

I got a message that a Google script has recently failed to finish successfully. How do I remove this script from my Google account and stop it permanently.

A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here. The script is used by the document Copy of Save My Gmail.

Error Message Count
Service using too much computer time for one day 84

Start Function Error Message Trigger End
10/27/14 11:24 PM savePDF Service using too much computer time for one day