Open this sheet: Google News Template
Make a copy of this sheet to the Child Folder created together with all the other files created for the Google Stack
Below the “Enter RSS feed below” cell, you can see a URL attached, change the last part of the URL to the keyword. The spaces of the keyword will be replaced to the plus sign..For example https://news.google.com/rss/search?q=Physiotherapy+Coquitlam or https://news.google.com/rss/search?q=Family+Lawyer+Surrey
Change the Anchor text to Keyword + News. For example: “Family Lawyer News” or “Physiotherapy News”
Go back to the template again and then make another copy. Instead of the keyword, search news for the City where the business is located.
For the anchor text as well, add the city instead of the keyword plus “News”
Interlink the two sheets by copying the link of the First sheet (Keyword News) to the Second Sheet (City News) and vice versa.
Go to the bottom most of the sheet and then paste the link
Again, do this to both the sheets. There will be the link of the Keyword News Sheet to the City News Sheet and there will be a link to the City News sheet on the Keywords Sheet
Change the Sheet tab Name below by double clicking the name\
Add both the links to the Master Doc File
