Enrichments /
No-Code Enrichment with
Use the SecurityTrails API for Domain SSL Certificates to Look Up Current and Historical Certificate Information for any Hostname
Sign Up Free

Use SecurityTrails API To Look Up Domain SSL Certificates for any Website

SecurityTrails is a data security company offering intel-reconnaissance and threat intelligence tools to cyber security teams. The SecurityTrails API makes it easy to enrich your dataset with any domain, DNS, and IP-related data. In this example, we are going to use the SSL Certificates API to look up current and historical certificate information using Gigasheet’s custom enrichment.

securitytrails api domain SSL certificates

Provider Website: https://securitytrails.com/
Provider Enrichment Docs:
Token / Registration Required:

How To Enrich A Spreadsheet With SecurityTrails:

For this example, my data is a simple list of 12 domains. Let’s use the SecurityTrails API to retrieve information about the SSL certificates.

Gigasheet data to enrich with securitytrails api domain SSL certificates

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from the SecurityTrails API docs.

cURL request for the securitytrails api domain SSL certificates

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the domain placeholder, “DOMAIN”, in the input, and then select our Domain column and click +Insert Column Reference. We also need to highlight the “YOUR_KEY” and paste our real key from SecurityTrails. Then click Next.

customizing the securitytrails api domain SSL certificates using Gigasheet
the final cURL request of the securitytrails api domain SSL certificates

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the SecurityTrails response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All since you can easily delete columns in Gigasheet.

preview of the response from the securitytrails api domain SSL certificates

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

confirm the number of rows to enrich with the securitytrails api domain SSL certificates

Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. The result will show generation of new columns based on the SecurityTrails SSL Certificates API. SecurityTrails has added SSL certificate information for each of the domains.

Gigasheet sheet enriched with the securitytrails api domain SSL certificates
Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever