< Back

Training: Google Sheets + OpenAI API To Automate Research Workflows


About the Author

Alok Jain
Alok Jain
Founder and CEO

Alok has 30 years of experience in research and 10 years applying AI. He's passionate about using technology to amplify - not replace - the craft of human-centered inquiry. Before starting DoReveal, Alok led research, strategy, and design initiatives at organizations like The World Bank, Carfax, Capital One, and Centene.

Follow me for more content
Summarize this article with AI
Open ChatGPT
As AI becomes a bigger part of the Insights industry, knowing how the technology works and how to integrate it is essential for those in many roles. It also opens up opportunities to build your own innovations. 

On March 27th, 1PM ET, in collaboration with Insights Association, we hosted a free training on how to automate your workflows using google sheets and openAI API. 

This session covered:
  • The basics of OpenAI and its API
  • How scripting works in Google Sheets (no coding experience needed)
  • Creating a script that processes data using OpenAI

The goal is to give you a foundation to start experimenting on your own. No programming background is required - just bring your curiosity and a willingness to learn.

Recording


Presentation Materials
Download Slides (includes links to all google sheets and code used in the training).


Join the Slack Community

We have created a slack community where you can ask questions, share ideas and collaborate with other researchers. Join the slack community


Inspired to see AI-powered insights in action?

Sign up for a free trial or book a personalized demo today and discover how DoReveal can transform your qualitative research.


👉 Start your free trial
👉 Book a demo
👉 See features & details