In the guide we will quickly show you how to connect data from Google Sheets into Artemis to quickly get insights

1. Log in to the Artemis app

2. Go to the data page and click add connector

   

3. Add a new connector by searching Sheets, clicking on the card, naming it Demo, and clicking Add Connector

   

4. Copy and paste this link into your browser.

   <https://docs.google.com/spreadsheets/d/1RVbDR049Tt1aPU6FhaGDlV60vf8L-vyigJviSHF3RAY/edit?usp=sharing>
   

5. Now Click Grant User Access and Sign into your Google Drive Account

   

6. Copy and paste this link where it says Sheet URL and click the Named Range dropdown and select NamedRange1

   <https://docs.google.com/spreadsheets/d/1RVbDR049Tt1aPU6FhaGDlV60vf8L-vyigJviSHF3RAY/edit?usp=sharing>
   

   

7. Once saved, head to the Compute page and paste in the query below

   SELECT * FROM demo.demo
   
   where state = 'California'
   

8. Save Table and name it California

   

9. In Analytics, add California.

   

10. Create new chart with California as the dataset

    

11. Build chart and add to dashboard!

Your dashboard should have a final chart on it and display the data brought in.

If you get stuck or have any questions, you can reach me at [email protected].