Creating a custom google map with spreadsheet
-
Hi Hi,
I recently saw the Seomoz Webinar "All About Google Places", and there was the advice to make a custom map with google spreadsheet. I tried it, but it hadn't worked. It seem, that this service is deprecated: http://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsmapwizard/makecustommap.htm
I can't find another way doing this with spreadsheets. Can anyone help?
Thank you!
André
-
Hmmm, that's troubling, Andre.
I honestly don't have an answer to this. May I recommend that you try submitting a thread to the Google Visualization API forum:
http://groups.google.com/group/google-visualization-api
I would love to be able to help you, but am afraid I don't know how to resolve the error messaging you are receiving. Maybe someone over there will have encountered it before and will be able to tell you what's up? Good luck!
Miriam
-
Hi Miriam,
thank you for your answer. Thist is exactly what I want, BUT, when I get it right, I need an API key that is no longer available. The website says:
The Maps API requires a free API key that's associated with your Google Account and the URL of your web site. You can sign up for one here, and substitute it as the value of the "&key=" parameter in the script tag below.
When you click "here", the upcoming website says, that you can't get this API key. I don't know, if I can use another API key, or something??
André
-
Greetings Andre,
I'm sorry your question didn't receive a prompt response.
Does this link help?
http://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsmapwizard/makecustommap.htm
Is that what you are trying to do?
Please, let me know.
Miriam
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Viral SlideShare = Google Penalty?
We recently published a slideshow on SlideShare.net and it ended up doing pretty well. It was featured on their homepage for 3 days, and we got quite a few embeds. Unfortunately, a few days later, our rankings in Google tumbled. I'm wondering if this killed our link velocity, which I suppose would have potentially got us a temporary, automated penalty? If you look at slide #4 and beyond, you'll notice that the logo links back to our homepage, and there's also a "View Quote" button that navigates to that specific quote, so users can find out more information, share it, or view any associated pictures. So, in total, there are quite a few backlinks in that slideshow (88 to be exact). Is this what likely caused our drop in rankings? Or is it more likely to be a coincidence? We haven't done anything else in the past couple of months, other than publish an infographic and a press release. And if this is a problem, how would we fix it? I can edit the slideshare and remove some of the links... but it seems sort of silly considering we haven't done anything blackhat. And, it would actually devalue our slideshow, because users would no longer be able to click through to the quotes. Thoughts?
Image & Video Optimization | | JABacchetta0 -
Google Places UK address has randomly changed to a US address in Texas!
Hello, one of my clients has 2 Google Places listings, both UK addresses. However one of them has randomly changed to a US address in Texas, and it won't let me update the country unless I create a new listing.... https://www.google.co.uk/maps/preview#!q=the+43+club&data=!4m16!1m15!4m8!1m3!1d22152595!2d12.5088275!3d47.73855!3m2!1i1440!2i774!4f13.1!7i10!9m1!6e0!10b1!17b1!25b1!6m1!1e1&fid=1 As you can see the second listing is Texas, but it should be: Tall Trees Cottage, Winkfield Road, Ascot, Berkshire, SL5 7EX. 0208 144 0166 Any help would be great. Thanks
Image & Video Optimization | | Kerry_Jones0 -
What Google+ URL to Take?
I could go with my Domain Name (/+tallahasseedefense) for simplicity sake and ease of remembering. However, would there be any SEO benefit to using a Google+ with both "Attorney" and "Tallahassee" in the URL (/+Casey&TorresAttorneysatLawTallahassee)? cna4R08
Image & Video Optimization | | DrewR0 -
Google+ advice
I am in the process of finalizing G+ pages for our financial institution's 70 locations. So far, the only things I see in my control (set-up only) are the basics - address, phone number, website, description, categories, etc. I do have some great information for additional information (drive-through hours, products, services, etc.), but I see that there's not a place for those. So aside from ensuring accuracy, choosing the best categories provided by Google, uploading quality pics, writing an effective/optimized description, and making sure my pins are correct, any other tips for making these the best pages the best I can? The only thing in my scope is page set-up. Our social media coordinator will be mitigating reviews and posting content. Thanks!
Image & Video Optimization | | SSFCU0 -
How do you know if you are listed in google+ local?
OK This Google+ local and Google places merge is confusing. My first question is how do you know if your company is listed in Google+ local? I've done a search in Google Plus (logged in with another gmail account) but couldn't find my company on the results. Second question is that I am also not able to be found in maps.google.com, is this related? Thanks
Image & Video Optimization | | donovanfox0 -
Confused about Google+ Local vs Google Places
If you're doing SEO for a new local business that currently does not have a Google Places listing (or a Google+ Local page), do you have to set up both for them? Or do you simply create the Google Places listing and wait for Google to merge it to a Google+ Local page? I am so confused!
Image & Video Optimization | | MarieHaynes0 -
My Google Places get mixed with another similar business
I'm having this issue with the keyword "miami printing" raking local for Miami, FL. My website is miamiprintingfl.com and part of my listing, photo, some reviews and etc, belongs to another listing miami-printing.net that last domain is not working at all. Is there anyway to solve this problem? Thank you Here my listing link: http://maps.google.com/maps/place?hl=en&ix=seb&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&biw=1600&bih=799&um=1&ie=UTF-8&q=miami+printing&fb=1&gl=us&hq=printing&hnear=0x88d9b0a20ec8c111:0xff96f271ddad4f65,Miami,+FL&cid=13803935199736027265&ei=mxFdT7LKJar50gGPk8WICg&sa=X&oi=local_result&ct=placepage-link&resnum=1&ved=0CI8BEOIJMAA And the other website that google its getting my listing mixed: http://maps.google.com/maps/place?hl=en&ix=seb&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&biw=1600&bih=799&um=1&ie=UTF-8&q=miami+printing&fb=1&gl=us&hq=printing&hnear=0x88d9b0a20ec8c111:0xff96f271ddad4f65,Miami,+FL&cid=16945901725821376380&ei=mxFdT7LKJar50gGPk8WICg&sa=X&oi=local_result&ct=placepage-link&resnum=3&ved=0CJ4BEOIJMAI
Image & Video Optimization | | jpgprinting0 -
Google Places - Different NAP on various directories...
My client's veterinary clinic uses a service called Localvets.com which is a division of Yext.com. This service updates listings and sponsors them across various directories. Since this is a referral service (they get paid for new clients) they use a custom phone number and custom website address for these listings. Question: Is this hurting the SEO potential of the Google Places listing since the N.A.P. are not the same? Thoughts?
Image & Video Optimization | | PMC-3120870