igforum.bio / connection-to-google-sheets-sistrix - 146862
A
%Start Connection to Google Sheets - SISTRIX Login Home / Support / API Reference / Connection to Google Sheets <h1>Connection to Google Sheets</h1> API Reference Domain methods Keyword methods Link Methods Optimizer methods Marketplace methods Connection to Microsoft Excel Connection to Google Sheets Google Data Studio Error-codes Back to overviewGoogle Sheets is part of Google Office. Since it already contains an &#8216;Import XML&#8217; function, the toolbox API data can be imported quickly and easily. We will show you how it works in this document.Google Sheets, formerly known as Google Docs, is Google&#8217;s web-based answer to Microsoft Excel.
Alexander Wang Member
access_time 5 minutes ago
%Start Connection to Google Sheets - SISTRIX Login Home / Support / API Reference / Connection to Google Sheets

Connection to Google Sheets

API Reference Domain methods Keyword methods Link Methods Optimizer methods Marketplace methods Connection to Microsoft Excel Connection to Google Sheets Google Data Studio Error-codes Back to overviewGoogle Sheets is part of Google Office. Since it already contains an ‘Import XML’ function, the toolbox API data can be imported quickly and easily. We will show you how it works in this document.Google Sheets, formerly known as Google Docs, is Google’s web-based answer to Microsoft Excel.
thumb_up Like (49)
comment Reply (0)
share Share
visibility 877 views
thumb_up 49 likes
D
It runs fully in your browser and saves all data to the Google Cloud. Therefore, it is not locked to one platform and a document can be viewed and edited by many users at the same time. <h2>Create a new Sheets documents</h2> In the first step, we will create a new Sheets document in Google Docs.
David Cohen Member
access_time 4 minutes ago
It runs fully in your browser and saves all data to the Google Cloud. Therefore, it is not locked to one platform and a document can be viewed and edited by many users at the same time.

Create a new Sheets documents

In the first step, we will create a new Sheets document in Google Docs.
thumb_up Like (38)
comment Reply (1)
thumb_up 38 likes
comment 1 replies
S
Sebastian Silva 2 minutes ago
To do that, go to the following URL in your browser: https://docs.google.com/spreadsheets/u/0/ Now c...
H
To do that, go to the following URL in your browser: https://docs.google.com/spreadsheets/u/0/ Now click on the big red plus button in the bottom right corner of your browser. A new Sheets document is created and you can start editing right away.
Hannah Kim Member
access_time 9 minutes ago
To do that, go to the following URL in your browser: https://docs.google.com/spreadsheets/u/0/ Now click on the big red plus button in the bottom right corner of your browser. A new Sheets document is created and you can start editing right away.
thumb_up Like (18)
comment Reply (0)
thumb_up 18 likes
A
<h2>Linking the API using importXML</h2> With the importXML function, Google Sheets gives you the option of importing external XML content into your Sheets document. Since the SISTRIX API also delivers the data in XML format, it is easy to link both systems. To use this function, simply type into a cell beginning with an equals sign and add two data points: =importXML("URL"; "XPath-Request") In the URL field, you must enter the exact URL of the SISTRIX API including your API key and all parameters.
Ava White Moderator
access_time 20 minutes ago

Linking the API using importXML

With the importXML function, Google Sheets gives you the option of importing external XML content into your Sheets document. Since the SISTRIX API also delivers the data in XML format, it is easy to link both systems. To use this function, simply type into a cell beginning with an equals sign and add two data points: =importXML("URL"; "XPath-Request") In the URL field, you must enter the exact URL of the SISTRIX API including your API key and all parameters.
thumb_up Like (16)
comment Reply (3)
thumb_up 16 likes
comment 3 replies
H
Harper Kim 10 minutes ago
You can request or view your API key on this site. An overview of all API methods is available in th...
J
James Smith 18 minutes ago
In order to retrieve the domain overview for the domain sistrix.de, for example, enter this URL: htt...
Show 1 more replies
E
You can request or view your API key on this site. An overview of all API methods is available in the existing documentation.
Elijah Patel Member
access_time 10 minutes ago
You can request or view your API key on this site. An overview of all API methods is available in the existing documentation.
thumb_up Like (42)
comment Reply (0)
thumb_up 42 likes
N
In order to retrieve the domain overview for the domain sistrix.de, for example, enter this URL: https://api.sistrix.com/domain.overview?api_key=YOURAPIKEY&amp;domain=sistrix.de The second field of the function describes the exact data from the XML response that should be copied into your Google spreadsheet. This description is given as an XPath definition.
Natalie Lopez Member
access_time 12 minutes ago
In order to retrieve the domain overview for the domain sistrix.de, for example, enter this URL: https://api.sistrix.com/domain.overview?api_key=YOURAPIKEY&domain=sistrix.de The second field of the function describes the exact data from the XML response that should be copied into your Google spreadsheet. This description is given as an XPath definition.
thumb_up Like (18)
comment Reply (2)
thumb_up 18 likes
comment 2 replies
S
Scarlett Brown 9 minutes ago
XPath may look a bit cryptic at first, but you will pick it up very quickly and the answers to the S...
D
David Cohen 11 minutes ago
You will then see the result on the right hand side. In the above example, you get the domain overvi...
O
XPath may look a bit cryptic at first, but you will pick it up very quickly and the answers to the SISTRIX API only contain simple XML. With an XPath tester like the one from Codebeautify.org, you can achieve results quickly. On that page, you can load the XML of the API with the button “Load URL” and test possible XPath variations at the bottom.
Oliver Taylor Member
access_time 7 minutes ago
XPath may look a bit cryptic at first, but you will pick it up very quickly and the answers to the SISTRIX API only contain simple XML. With an XPath tester like the one from Codebeautify.org, you can achieve results quickly. On that page, you can load the XML of the API with the button “Load URL” and test possible XPath variations at the bottom.
thumb_up Like (11)
comment Reply (2)
thumb_up 11 likes
comment 2 replies
A
Alexander Wang 4 minutes ago
You will then see the result on the right hand side. In the above example, you get the domain overvi...
S
Sebastian Silva 6 minutes ago

Further Sources

How To Use importXML in Google Docs (EN, builtvisible.com) API ReferenceDoma...
N
You will then see the result on the right hand side. In the above example, you get the domain overview of the page with this expression: //@value Put together, you can enter this function into the spreadsheet cell: =importXML("https://api.sistrix.com/domain.overview?api_key=YOURAPIKEY&amp;domain=sistrix.de"; "//@value") After entering the function, Google will execute the API request for you and insert the current data from the SISTRIX API into your Google spreadsheet. All other API methods can be incorporated analogously to this process.
Natalie Lopez Member
access_time 32 minutes ago
You will then see the result on the right hand side. In the above example, you get the domain overview of the page with this expression: //@value Put together, you can enter this function into the spreadsheet cell: =importXML("https://api.sistrix.com/domain.overview?api_key=YOURAPIKEY&domain=sistrix.de"; "//@value") After entering the function, Google will execute the API request for you and insert the current data from the SISTRIX API into your Google spreadsheet. All other API methods can be incorporated analogously to this process.
thumb_up Like (50)
comment Reply (1)
thumb_up 50 likes
comment 1 replies
L
Lily Watson 18 minutes ago

Further Sources

How To Use importXML in Google Docs (EN, builtvisible.com) API ReferenceDoma...
M
<h2>Further Sources</h2>How To Use importXML in Google Docs (EN, builtvisible.com) API ReferenceDomain methodsKeyword methodsLink MethodsOptimizer methodsMarketplace methodsError-codesConnection to Google SheetsConnection to Microsoft Excel 02.07.2019 API Reference Domain methods Keyword methods Link Methods Optimizer methods Marketplace methods Connection to Microsoft Excel Connection to Google Sheets Google Data Studio Error-codes Back to overview German English Spanish Italian French
Madison Singh Member
access_time 27 minutes ago

Further Sources

How To Use importXML in Google Docs (EN, builtvisible.com) API ReferenceDomain methodsKeyword methodsLink MethodsOptimizer methodsMarketplace methodsError-codesConnection to Google SheetsConnection to Microsoft Excel 02.07.2019 API Reference Domain methods Keyword methods Link Methods Optimizer methods Marketplace methods Connection to Microsoft Excel Connection to Google Sheets Google Data Studio Error-codes Back to overview German English Spanish Italian French
thumb_up Like (46)
comment Reply (1)
thumb_up 46 likes
comment 1 replies
S
Scarlett Brown 20 minutes ago
Connection to Google Sheets - SISTRIX Login Home / Support / API Reference / Connection to Google Sh...

Write a Reply

Similar Discussions