search

dsottimano / xmlsitemap-extractor-google-sheets

38 stars 22 forks source link

Can you please explain how to add this script into the script editor? #3

Open corinafong opened 5 years ago

corinafong commented 5 years ago

I'm a bit of a noob when it comes to scripts and was wondering if you could explain how I add this into the script editor. Could you provide exactly what I should paste into the script editor? Thanks!

garrettatx commented 2 years ago

Related to the article at https://opensourceseo.org/extract-urls-xml-sitemaps-google-sheets/

Is Script Editor now the same as Extensions > Apps Script? If so, I've copied the code there, saved, run, and allowed permission. When I tried to use the function in Google Sheets, I get this error: unknown function:'sitemap'.

Are there additional steps needed to get this working?

dsottimano commented 2 years ago

@garrettatx I renamed the formula to EXTRACT_SITEMAP https://github.com/dsottimano/xmlsitemap-extractor-google-sheets/tree/master and didn't update the post, sorry.

Alternately, you can edit the code here https://github.com/dsottimano/xmlsitemap-extractor-google-sheets/blob/3ca4916b72e567d069145f76130119618fbc1c6a/xmlscript.js#L18 and change the function name from EXTRACT_SITEMAP to sitemap (or whatever you want)