May the 4th be with you! To celebrate the occasion, we are using Gigasheet to access the Star Wars API from SWAPI (Swah-pee). This contains the world's first quantified and programmatically-accessible data source for the Star Wars canon universe through The Force Awakens. And honestly, that probably a good stopping point. We can all just pretend The Last Jedi and The Rise of Skywalker never happened, right?
Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTPs request from the SWAPI website.
Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the latitude and longitude. In this case, we first highlight the term“people” in the input, and then select our Star Wars Data Type column and click +Insert Column Reference. We then repeat the same thing for the number, replacing “1”, with our Item Number Column. Then click Next.
Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the SWAPI Star Wars API response. At this point select the fields you want to be inserted into your sheet. We suggest hitting Select All, because you can always delete columns later.
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.
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 SWAPI Star Wars API.
And here are some stats on some of our favorite characters!