Question: How can I automate generating formulas in Google Sheets or Excel without having to learn coding?

FormulaGenerator is an AI-powered tool that helps you generate Excel formulas, VBA automations and SQL queries. It can generate formulas based on text prompts, find and fix errors, and generate VBA code. It's available as a web app or as a Google Sheets add-on, and you can get 10 requests per month for free. For more usage, you can pay $4.99 per month for a Premium Membership.

Another good option is ManyExcel, which also can generate formulas, regex patterns and scripts. With an AI Formula Generator, you can convert plain text into complex formulas with explanations. It also works with Google Sheets through Apps Scripts for automating tasks. The tool offers a free plan with limited use and a Pro plan for $5/month, with unlimited formula generation and other features.

If you prefer to work directly with Google Sheets, Flowshot is a Google Sheets AI plugin that automates repetitive tasks, generates formulas and images, and lets you train custom AI models. It offers several pricing tiers from $9 to $379 per month, and a custom plan for unlimited AI model usage. That makes it a good option for boosting Google Sheets productivity.