# MagTag Lists From Google Spreadsheets ## Overview ![](https://cdn-learn.adafruit.com/assets/assets/000/097/742/medium800/circuitpython_banner.jpg?1607808880) **Cloud-connected** , programmable devices like Adafruit’s _ **MagTag** _ make it easy to pull live data from internet sources: [tides](https://learn.adafruit.com/magtag-tides-viewer), [space launches](https://learn.adafruit.com/spacex-next-launch-display-with-adafruit-magtag), [transit schedules](https://learn.adafruit.com/nextbus-transit-predictions-for-adafruit-magtag) and more. Getting _your own stuff_ out there isn’t always so easy though. This often involves server hosting, writing web applications…generally a whole extra layer of knowledge, resources and patience that most of us don’t have. Why reinvent the wheel? We’ve learned a pretty easy way to do this using [_ **Google Sheets** _](https://docs.google.com/spreadsheets) — a free, web-based spreadsheet platform. You might already have an account. One can create and edit lists and reminders easily using a web browser or mobile app…then, combined with some CircuitPython programming, have this information displayed on MagTag. Google Sheets allows multiple people to _collaborate_ on the same document. Or, share just the data feed while the original document is off-limits to others. We’ll demonstrate a couple simple examples in this guide…but if you really get to know your way around Google Sheets, it’s possible to have it (and thus MagTag) showing dynamic data like stock quotes or days-remaining counters. Some potent magic! ## Parts Required The MagTag starter kit includes an e-ink development board, LiPoly battery and magnetic feet…bring-your-own USB type A to type C cable. Or the individual pieces can be rounded up separately… ### Adafruit MagTag Starter Kit - ADABOX017 Essentials [Adafruit MagTag Starter Kit - ADABOX017 Essentials](https://www.adafruit.com/product/4819) The **Adafruit MagTag** combines the new ESP32-S2 wireless module and a 2.9" grayscale E-Ink display to make a low-power IoT display that can show data on its screen even when power is removed! The ESP32-S2 is great because it builds on the years of code and support for the... In Stock [Buy Now](https://www.adafruit.com/product/4819) [Related Guides to the Product](https://learn.adafruit.com/products/4819/guides) ![MagTag dev board with enclosure pieces, four magnet feet, and lipoly battery](https://cdn-shop.adafruit.com/640x480/4819-02.jpg) ### Adafruit MagTag - 2.9" Grayscale E-Ink WiFi Display [Adafruit MagTag - 2.9" Grayscale E-Ink WiFi Display](https://www.adafruit.com/product/4800) The Adafruit MagTag combines the ESP32-S2 wireless module and a 2.9" grayscale E-Ink display to make a low-power IoT display that can show data on its screen even when power is removed! The ESP32-S2 is great because it builds on the years of code and support for the ESP32 and also adds... In Stock [Buy Now](https://www.adafruit.com/product/4800) [Related Guides to the Product](https://learn.adafruit.com/products/4800/guides) ![Angled shot of rectangle-shaped electronic ink display breakout with the text: "MAGTAG 2025 Edition with SSD1680 Chipset"](https://cdn-shop.adafruit.com/640x480/4800-10.jpg) ### USB Type A to Type C Cable - approx 1 meter / 3 ft long [USB Type A to Type C Cable - approx 1 meter / 3 ft long](https://www.adafruit.com/product/4474) As technology changes and adapts, so does Adafruit. This   **USB Type A to Type C** cable will help you with the transition to USB C, even if you're still totin' around a USB Type A hub, computer or laptop. USB C is the latest industry-standard connector for... In Stock [Buy Now](https://www.adafruit.com/product/4474) [Related Guides to the Product](https://learn.adafruit.com/products/4474/guides) ![Angled shot of a coiled black, USB-C to USB-A cable.](https://cdn-shop.adafruit.com/640x480/4474-02.jpg) ### Lithium Ion Polymer Battery with Short Cable - 3.7V 420mAh [Lithium Ion Polymer Battery with Short Cable - 3.7V 420mAh](https://www.adafruit.com/product/4236) Lithium-ion polymer (also known as 'lipo' or 'lipoly') batteries are thin, light, and powerful. The output ranges from 4.2V when completely charged to 3.7V. This battery has a capacity of 420mAh for a total of about 1.55 Wh. If you need a larger (or smaller!) battery, In Stock [Buy Now](https://www.adafruit.com/product/4236) [Related Guides to the Product](https://learn.adafruit.com/products/4236/guides) ![Lithium Ion Polymer Battery 3.7v 420mAh with JST 2-PH connector and short cable](https://cdn-shop.adafruit.com/640x480/4236-04.jpg) ### Also needed: - **WiFi network** (802.11 b/g/n) - A desktop or laptop **computer** is required for initial setup: any **text editor** will suffice - A **Google account** to create and collaborate on cloud-based spreadsheets. In the next section—specifically the “CircuitPython Internet Test” page—you’ll create a **_secrets_ file** to access your wireless network. This is a necessary step, don’t just skip ahead. If you’ve done some WiFi-connected MagTag projects before, you probably already have this file. - [Next Page](https://learn.adafruit.com/collaborative-spreadsheets-to-magtag/install-circuitpython.md) ## Featured Products ### Adafruit MagTag Starter Kit - ADABOX017 Essentials [Adafruit MagTag Starter Kit - ADABOX017 Essentials](https://www.adafruit.com/product/4819) The **Adafruit MagTag** combines the new ESP32-S2 wireless module and a 2.9" grayscale E-Ink display to make a low-power IoT display that can show data on its screen even when power is removed! The ESP32-S2 is great because it builds on the years of code and support for the... In Stock [Buy Now](https://www.adafruit.com/product/4819) [Related Guides to the Product](https://learn.adafruit.com/products/4819/guides) ### Adafruit MagTag - 2.9" Grayscale E-Ink WiFi Display [Adafruit MagTag - 2.9" Grayscale E-Ink WiFi Display](https://www.adafruit.com/product/4800) The Adafruit MagTag combines the ESP32-S2 wireless module and a 2.9" grayscale E-Ink display to make a low-power IoT display that can show data on its screen even when power is removed! The ESP32-S2 is great because it builds on the years of code and support for the ESP32 and also adds... In Stock [Buy Now](https://www.adafruit.com/product/4800) [Related Guides to the Product](https://learn.adafruit.com/products/4800/guides) ### USB Type A to Type C Cable - approx 1 meter / 3 ft long [USB Type A to Type C Cable - approx 1 meter / 3 ft long](https://www.adafruit.com/product/4474) As technology changes and adapts, so does Adafruit. This   **USB Type A to Type C** cable will help you with the transition to USB C, even if you're still totin' around a USB Type A hub, computer or laptop. USB C is the latest industry-standard connector for... In Stock [Buy Now](https://www.adafruit.com/product/4474) [Related Guides to the Product](https://learn.adafruit.com/products/4474/guides) ### Lithium Ion Polymer Battery with Short Cable - 3.7V 420mAh [Lithium Ion Polymer Battery with Short Cable - 3.7V 420mAh](https://www.adafruit.com/product/4236) Lithium-ion polymer (also known as 'lipo' or 'lipoly') batteries are thin, light, and powerful. The output ranges from 4.2V when completely charged to 3.7V. This battery has a capacity of 420mAh for a total of about 1.55 Wh. If you need a larger (or smaller!) battery, In Stock [Buy Now](https://www.adafruit.com/product/4236) [Related Guides to the Product](https://learn.adafruit.com/products/4236/guides) ## Related Guides - [Adafruit MagTag](https://learn.adafruit.com/adafruit-magtag.md) - [Google Graveyard with Adafruit MagTag](https://learn.adafruit.com/google-graveyard-with-adafruit-magtag.md) - [CircuitPython Display_Text Library](https://learn.adafruit.com/circuitpython-display-text-library.md) - [MagTag Twitter Display](https://learn.adafruit.com/magtag-twitter-display.md) - [What’s Fresh Today? In-Season Produce Reminder for Adafruit MagTag](https://learn.adafruit.com/seasonal-produce-for-adafruit-magtag.md) - [MagTag AR Tarot Card Reading](https://learn.adafruit.com/magtag-tarot-cards.md) - [MagTag Progress Displays](https://learn.adafruit.com/magtag-progress-displays.md) - [CircuitPython Web Workflow Code Editor Quick Start](https://learn.adafruit.com/getting-started-with-web-workflow-using-the-code-editor.md) - [Language Flashcards on the MagTag](https://learn.adafruit.com/magtag-flashcards.md) - [MagTag Case](https://learn.adafruit.com/magtag-case.md) - [MagTag 3D Printed Stand Case](https://learn.adafruit.com/magtag-3d-printed-stand-case.md) - [MagTag Cat Fed Clock](https://learn.adafruit.com/magtag-cat-feeder-clock.md) - [Cheerlights Holiday Wreath with Animations](https://learn.adafruit.com/cheerlights-led-animations.md) - [MagTag Literary Quote Clock](https://learn.adafruit.com/magtag-literary-quote-clock.md) - [Deep Sleep with CircuitPython](https://learn.adafruit.com/deep-sleep-with-circuitpython.md) - [Keypad and Matrix Scanning in CircuitPython](https://learn.adafruit.com/key-pad-matrix-scanning-in-circuitpython.md)