I copied and pasted this into my sheet and it worked perfectly. Q: How can I modify this query in Google Sheets such that the first value in the Where clause refers to the contents in cell F3 in the same sheet rather than the literal value “contains.” :=QUERY(Transactions!$B$1:$K,“Select B,C,D,E where D contains '”&B2&“’ and '”&C2&“’ = ‘TRUE’”,1)Ī: You can use the INDIRECT function to reference the contents of cell F3 in the Where clause of your QUERY function. I waited about 3-5 seconds for the answer. This is the exact wording of my question and ChatGPT’s answer. I modified my Query to reference the value in this dropdown but I couldn’t get it to work. Note that in this case, the Where clause will match if the Category in the Transactions sheet “equals” the value in B2 of the Query tab.īy changing the Where clause from “Where =” to “Where contains”, the query will match if the category in the Transactions sheet contains the value in B2.īut I had to manually edit the formula – replacing = with contains and I wondered if I could create another dropdown containing two values, “Contains” or the “=” sign.
This is what my Query looks like so far: =QUERY(Transactions!$B$1:$K,"Select B,C,D,E where D = '"&B2&"' and '"&C2&"' = 'TRUE'",1) Autocomplete repetitive tasks, use ChatGPT, and train custom AI models with the all-in-one AI toolkit. Flowshot – Google Sheets AI via Flowshot.aiĮasy to use, powerful AI in Google Sheets. Pricing: Free to $49 or higher with an enterprise planĦ.They also have a small gallery of ChatGPT templates. This add-on lets you use a custom formula to automatically complete any text-based task, from categorizing and summarizing to formatting and translating. Use powerful AI models like GPT-3 in Google Sheets. One formula to transform, extract, or summarize any text that works just like SUM or VLOOKUP and generates answers. Learn more: Website and Google Workspace Marketplace.You can use it for all sorts of tasks on text: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining, etc It is built on top OpenAI ChatGPT, GPT-3 and GPT-4 models. It enables you to use ChatGPT directly in Google Sheets™ and Docs™. GPT for Sheets™ and Docs™ is an AI writer for Google Sheets™ and Google Docs™. GPT for Sheets and Docs is currently the ChatGPT extension with the highest number of installs and reviews. It was created by Talarian, maker of the super-popular “Yet Another Mail Merge” extension for Google Sheets. Here’s another more detailed post about how to connect ChatGPT To Google Sheets using Google Apps Script.Īnd here’s a video on this topic from yet another source: This concise blog post provides example code and a written tutorial for deploying it. Want to access ChatGPT from Google Sheets, but don’t want to use a third-party extension? Google Apps Script to the rescue! Even though you can roll back changes in Google Sheets, we don’t recommend experimenting with these workflows in your Tiller-powered sheets until you’re sure they’re safe, private, and effective. To protect your privacy, always exercise caution when connecting third-party extensions, code, and templates to Google Sheets. So here are a few extensions and workflows for connecting ChatGPT and your Google Sheets. And if you want to start experimenting with natural language AI in your Google Sheets right now, ChatGPT is your best bet. It may take the form of Bard, an AI chatbot based on LaMDA, which Google started working on back in 2015.īut even when Google has its own native AI tools available in Google Sheets, some people may prefer OpenAI’s ChatGPT. When Google brings generative AI to Google Sheets, it won’t be via OpenAI’s familiar ChatGPT. Later this spring, Microsoft Copilot will bring OpenAI’s ChatGPT to Microsoft 365, including Excel.Īnd Google is rapidly bringing generative AI to its entire Workspace suite, starting with Docs and Gmail. Soon everyone will have easy, optional access to native AI tools in their spreadsheets, unleashing new ways to organize, visualize, and understand data. However, we’re excited by the potential of generative AI. These experiments are isolated from our product development and experience to maintain Tiller’s strict privacy and security protocols. Along with many members of the Tiller Community, Tiller’s team is enthusiastically experimenting with ChatGPT in Google Sheets.