Awesome
<a href="https://302.ai/" target="_blank"> <img src="./public/302banner1.jpg" alt="302.ai"> </a>[Sponsor - 赞助]
<a href="https://302.ai/" target="_blank">302.AI</a>是一个汇集全球顶级品牌的AI超市,按需付费,零月费,零门槛使用各种类型AI。新用户免费<a href="https://gpt302.saaslink.net/Y3CmW1" target="_blank">领1美元额度⚡️</a>
每天5美金额度的<a href="https://weijunext-all.tools302.com?region=1&pwd=8729" target="_blank">GPT-4🤖</a>
SmartExcel.cc
Generate the Excel formulas you need in seconds using AI.
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:
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.
<a href="https://www.buymeacoffee.com/weijunext" target="_blank"><img src="https://cdn.buymeacoffee.com/buttons/v2/default-yellow.png" alt="Buy Me A Coffee" style="height: 41px !important;width: 174px !important;" ></a>
<a href="https://afdian.net/a/weijunext" target="_blank"><img src="./public/afd.png" alt="在爱发电支持我" style="height: 50px !important"></a>
<img src="./public/zs.jpeg" alt="赞赏作者" style="height: 200px; width: 200px">