Skip to content

Generate the Excel formulas you need in seconds using ChatGPT.

License

Notifications You must be signed in to change notification settings

FantomShift/smart-excel-ai

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🌍 English简体中文

Generate the Excel formulas you need in seconds using AI.

Generate the Excel formulas

How it works

This project uses the ChatGPT API and the Vercel AI SDK with streaming. It constructs a prompt based on the form and user input, sends it to the ChatGPT API with a Vercel Edge Function, then streams the response back to the application UI.

Stack

SmartExcel is built on the following stack:

  • Next.js – Frontend/Backend
  • TailwindCSS – Styles
  • Postgres and Prisma - database and storage(How to use?)
  • Next-auth - Authentication(How to use?)
  • ChatGPT - Generate the Excel formulas
  • Upstash - Redis(How to use?)
  • Lemon Squeezy - payments(How to use?)
  • Google Analytics - Analytics(How to use?)
  • Docker - Development Storage(How to use?)
  • Vercel - Hosting

If you are unfamiliar with some of the tech stacks, please click on the "How to use" links above to read my Chinese blog, or visit my another public repo - Learn Next.js Stack

Running Locally

After cloning the repo, you need to copy the .env.example file to create a .env file and fill in the required fields.

Open Upstash and Create Redis application.

Then write UPSTASH_REDIS_REST_URL and UPSTASH_REDIS_REST_TOKEN to .env.

Then, run the application in the command line and it will be available at http://localhost:3000.

pnpm i

pnpm run dev

One-Click Deploy

Deploy the example using Vercel:

Deploy with Vercel

About Me

Full-Stack Engineer, Open-Source Next.js Artist & AI Enthusiast.

全栈工程师,Next.js 开源手艺人,AI降临派。

My Blog
Github
Twitter/X
Twitter/X - En
Medium
掘金
知乎
微信交流群

If this project is helpful to you, star the repo and buy be a coffee, thank you.

Buy Me A Coffee

在爱发电支持我

赞赏作者

Star History

Star History Chart

About

Generate the Excel formulas you need in seconds using ChatGPT.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • TypeScript 72.1%
  • CSS 14.9%
  • MDX 9.1%
  • JavaScript 3.9%