Installation Instructions:

1. Copy script.js from this repo and paste into new Google sheet script editor (from the Tools menu, choose script editor)
2. Find “API_KEY” in the code and replace with your Sistrix.com API key
3. Hit save, name your new script
4. Go back to the spreadsheet, refresh the page
5. In the top menu of the Spreadsheet, you’ll see “Sistrix Functions”, click on it, choose “check api balance”
6. Authorize with your Google account
7. All done! Go to the spreadsheet and start typing in any of the formulas listed here.

Functions

VISIBILITY_INDEX_SISTRIX(type, url, country, mobile, date, history, excludeHeaders) ⇒

Returns Sistrix visibility index

INDEXED_PAGES_SISTRIX(type, url, history, excludeHeaders) ⇒

Returns Sistrix number of indexed pages for a domain

DOMAIN_KEYWORD_COUNT_SISTRIX(type, url, country, mobile, date, history, excludeHeaders) ⇒

Returns Sistrix the number of Google organic search index keywords found on the domain

DOMAIN_KEYWORD_COUNT_TOP_10_SISTRIX(type, url, country, mobile, date, history, excludeHeaders) ⇒

Returns Sistrix the number of Top 10 Google organic search index keywords found on the domain

DOMAIN_OPPORTUNITIES_SISTRIX(type, url, country, mobile, limit, offset, excludeHeaders) ⇒

Returns Keyword opportunities

DOMAIN_IDEAS_SISTRIX(type, url, country, mobile, limit, offset, excludeHeaders) ⇒

Returns Keyword ideas

DOMAIN_AGE_SISTRIX(type, url, excludeHeaders) ⇒

Returns Domain age

DOMAIN_COMPETITORS_SEO_SISTRIX(type, url, country, num, excludeHeaders) ⇒

Returns SEO Competitors

DOMAIN_COMPETITORS_SEM_SISTRIX(type, url, country, num, excludeHeaders) ⇒

Returns SEM Competitors

VISIBILITY_INDEX_SISTRIX(type, url, country, mobile, date, history, excludeHeaders) ⇒

Returns Sistrix visibility index

Kind: global function
Returns: Returns organic keywords count, organic traffic, organic cost, adwords data
Link: https://www.sistrix.com/api/domain/#domainsichtbarkeitsindex domainsichtbarkeitsindex
Customfunction:

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
country	"us"	OPTIONAL The country database you want to search from
mobile	true	OPTIONAL true for Mobile index
date	2016-09-15	OPTIONAL YYYY-MM-DD format
history	true	OPTIONAL true for historical
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false

INDEXED_PAGES_SISTRIX(type, url, history, excludeHeaders) ⇒

Returns Sistrix number of indexed pages for a domain

Kind: global function
Returns: Returns date YYMMDD, index page count
Customfunction: @link https://www.sistrix.com/api/domain/#domainpages domainpages

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
history	true	OPTIONAL true for historical
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false

DOMAIN_KEYWORD_COUNT_SISTRIX(type, url, country, mobile, date, history, excludeHeaders) ⇒

Returns Sistrix the number of Google organic search index keywords found on the domain

Kind: global function
Returns: Returns date, keyword count
Customfunction:

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
country	"us"	OPTIONAL The country database you want to search from
mobile	true	OPTIONAL true for Mobile index
date	2016-09-15	OPTIONAL YYYY-MM-DD format
history	true	OPTIONAL true for historical
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false

DOMAIN_KEYWORD_COUNT_TOP_10_SISTRIX(type, url, country, mobile, date, history, excludeHeaders) ⇒

Returns Sistrix the number of Top 10 Google organic search index keywords found on the domain

Kind: global function
Returns: Returns date, keyword count
Customfunction:

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
country	"us"	OPTIONAL The country database you want to search from
mobile	true	OPTIONAL true for Mobile index
date	2016-09-15	OPTIONAL YYYY-MM-DD format
history	true	OPTIONAL true for historical
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false

DOMAIN_OPPORTUNITIES_SISTRIX(type, url, country, mobile, limit, offset, excludeHeaders) ⇒

Returns Keyword opportunities

Kind: global function
Returns: Returns Gain, Keywords, Positions, Urls ,Competition level
Customfunction: @link https://www.sistrix.com/api/domain/#domainopportunities domainopportunities

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
country	"us"	OPTIONAL The country database you want to search from
mobile	true	OPTIONAL true for Mobile index
limit	10	OPTIONAL number of results to return. Default is 10
offset	true	OPTIONAL works with limit, get results from a specific line number
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false

DOMAIN_IDEAS_SISTRIX(type, url, country, mobile, limit, offset, excludeHeaders) ⇒

Returns Keyword ideas

Kind: global function
Returns: Returns Keywords, Competition level
Customfunction: @link https://www.sistrix.com/api/domain/#domainideas domainideas

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
country	"us"	OPTIONAL The country database you want to search from
mobile	true	OPTIONAL true for Mobile index
limit	10	OPTIONAL number of results to return. Default is 10
offset	true	OPTIONAL works with limit, get results from a specific line number
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false

DOMAIN_AGE_SISTRIX(type, url, excludeHeaders) ⇒

Returns Domain age

Kind: global function
Returns: Returns Age YYYYMMDD
Customfunction: @link https://www.sistrix.com/api/domain/#domainage domainage

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false

DOMAIN_COMPETITORS_SEO_SISTRIX(type, url, country, num, excludeHeaders) ⇒

Returns SEO Competitors

Kind: global function
Returns: Returns Competing domain, match
Customfunction: @link https://www.sistrix.com/api/domain/#domaincompetitorsseo domaincompetitorsseo

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
country	"us"	OPTIONAL The country database you want to search from
num	10	OPTIONAL number of results to return. Default is 10
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false

DOMAIN_COMPETITORS_SEM_SISTRIX(type, url, country, num, excludeHeaders) ⇒

Returns SEM Competitors

Kind: global function
Returns: Returns Competing domain, match
Customfunction: @link https://www.sistrix.com/api/domain/#domaincompetitorssem domaincompetitorssem

Param	Type	Description
type	"domain"	REQUIRED The type of URL you want results for. Accepted values are: domain, host, path, url
url	"example.com"	REQUIRED The url
country	"us"	OPTIONAL The country database you want to search from
num	10	OPTIONAL number of results to return. Default is 10
excludeHeaders	true	OPTIONAL true to exclude the column headers. Default is false