We’ve authoritatively discharged the API for Google Sheets and need to take you on a fast element visit.
This Google Sheets add-on permits clients to assemble URL metrics effectively without utilizing code legitimately in a Google Sheet and gives a couple of additional functions to help you control information.
Previously, in the event that you needed link metrics for several URLs, you either needed to enter them physically one at once, or you required specialized ability to utilize the LinkScape API. Along these lines, I manufactured this free Google Sheets add-on, and now you can pull link metrics for those URLs in seconds, no coding required.
Here are a couple of utilization cases for the API for Sheets add-on:
- Get Spam Score in metric to help poisonous link investigation (paid arrangement required).
- Get space authority and page expert in mass to help you survey the nature of locales for link outreach, area valuation, and the sky is the limit from there (accessible with free and paid plans).
- Utilize worked in custom formulas to parse URLs, spare URLs to the Wayback Archive, and so on., all without composing entangled settled formulas or utilize standard expressions.
This is what you can expect as yield from the add-on:
The only thing you’ll have to begin is a Google record and API certifications (a free arrangement is accessible).
- The free arrangement will permit the collection of space authority and page expert for 200 URLs one after another, at a pace of 10 URLs for each 10 seconds.
- The paid arrangement will permit all metrics for 10,000 URLs one after another with no rate constraining.
Once you have the add-on introduced, you’ll have to enter your API accreditations to initiate the apparatus. From that point, just select your metrics and add in your URLs to get the report working.
The formulas tab
There are a couple of helpful custom formulas that accompany the add-on. Just snap on the “formulas” tab at the base of the add-on to see them. As you type any of these formulas, a help record will spring up to manage you.
For instance, utilize the =PARSE_URL equation to rapidly parse URLs into the root, way, stay, and more without composing novel-length formulas or recall troublesome customary expressions.
Stuck? Snap on the “help” tab to show additional information.
That is it! We trust you appreciate the add-on and we invite your input.