| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | #REF! | Go to File > Make a copy to get started | |||||||
2 | What you need: | How to: | Did this help you? | ||||||
3 | To extract Q&A: | 1. Download Google Scraper for Chrome Extension | Share with others or drop me a tweet on Twitter, I'd love to know! Here are my social links; | ||||||
4 | 1. Google Scraper for Chrome | 2. Search in Google for a key question | |||||||
5 | Link to Google Scraper for Chrome | 3. Expand Relevant Questions for as many as you need | #REF! | #REF! | |||||
6 | 4. Right click and 'Scrape Similar' using the provided Xpath | ||||||||
7 | To add your clients visibility; | 5. Click 'Copy To Clipboard' (bottom right of Scraper window). Copy + paste column A into; 'Google Questions and Answers - Tidy' tab | |||||||
8 | 2. RankTank Keyword Tool (Sheet) | www.hannahrampton.co.uk | |||||||
9 | To get the Rank and URL, you can use the RankTank Live Keyword Checker | Go Now! | |||||||
10 | Link to RankTank Keyword Tool | #REF! | |||||||
11 | |||||||||
12 | XPath for extracting Q&A; | ||||||||
13 | //g-accordion-expander | ||||||||
14 | |||||||||