GPT for Sheets™ Docs™ Forms™ Slides™ Gmail™ ChatGPT, Perplexity, GPT-4o, GPT-4o-Mini, GPT-4, o1-preview, o1-mini, GPT-3 Turbo, GPT-4-Turbo, DALL-E, Replicate, Gemini, Claude, Mistral, Perplexity, Cloudinary.
AI-Powered writing Assistant from OpenAI™ 

COVER CASES:
- AI with web access
- Build-in functions for scrapping site
- Generation AI images with Dalle-2, Dalle-3, also you can use any image/animation model from Replicate.com to generate any type of images
- GPT VISION - using AI for pulling content from Image
- Programmatic SEO
- Generation SEO strategy 
- Getting places via Google Maps API (Google Place API)
- Data Enrichment, Apollo, Prospeo integration for getting emails by domain, getting all info by linkedin url. Now it covers most of Clay features.
- Data Extraction
- Content writing
- Web Scrapping
- SERP functions - getting search engine results (bing, google)
- Integration with DATA for SEO: To get top keywords of your competitors
- Integration with DATA for SEO: Get keywords volume, competition
- Scrapping headers, paragraphs, meta description by urls
- Social Media content generating & posting
- Integration with Replicate, Twitter, Facebook, Instagram, LinkedIn (any service that support API Rest integration)
- Generation SEO Full articles

 IMPORTANT! If you encounter the message: "Authorization is required to perform this action."
- Use personal google account
- You used multiple Google accounts in the same Chrome session, please create a new browser profile and log in again
- Ask admin of your workspace account to allow execute add-on

UPD: 21 December
- Fix AUTO-REPLACEMENT feature. Functions with #ERROR will not replaced with the text. Only successful funcs.


UPD: 8 November
- Data Enrichment: Apollo, Prospeo integration for getting emails by domain, getting all info by linkedin url. Now it covers most of Clay features.

UPD: 27 October
- GOOGLE_MAPS_GET_PLACES() function now fetches a list of places near a specified location using the Google Places API. It provides detailed data such as name, address, and more, tailored for various types of places like restaurants, cafes, and parks. Users can specify search parameters including location, radius, and type to refine their results effectively.

- GOOGLE_MAPS_PLACE_GOOGLE() function allows users to retrieve detailed information about a specific place, such as landmarks or businesses, directly from the Google Places API. By simply providing the place name or address, users can access comprehensive details including ratings, reviews, and contact information, enhancing the ability to gather data on locations of interest.

UPD: 21 October
- Add SEND_EMAIL() function enables bulk email sending directly from Google Sheets through your Gmail account. It allows users to send personalized email messages to multiple recipients in one go, making it perfect for outreach campaigns, updates, and notifications.
- Use as Mail Merge Add-on for Google Sheets

UPD: September 18
- Integration with Replicate.com - now you can generate images in bulk using any AI model for image generation from Sheets!!!

- Integration with Cloudinary.com - allows you to upload  in bulk images in from Sheets on hosting! using their urls. Programmatic SEO!

- GPT_CUSTOM() - customize any params like model, temperature, top_p, max_tokens for your request.


UPD: September 13
- Added supporting o1-preview and o1-mini models for ChatGPT models

UPD: 5 Sept
- Added =GOOGLE_INDEXING() - Allows site owners to directly notify Google when pages are added or updated.

UPD: 26 July
- Increase max results for SERP() functions. Adopt for scrapping data, emails from instagram, linkedin, twitter (x)

UPD: 26 July
- Added SEO_BLOG() - Generates an SEO-optimized blog post (1k+ words) based on the provided title, writing tone, and language. in Google Sheets

- Added SEO_OUTRANK() Analyzes the given URL and provides content recommendations to outrank it in search engine results

- Added SEO_STRATEGY() - Generates a comprehensive SEO strategy based on the provided keywords and language


UPD: 20 July
- Add supporting OpenAI GPT-4o-Mini

- API() - allows you to pull/push content directly from Sheets into your site, service, database, Airtable integration

=GPT_IMAGE() and =GPT_CREATE_IMAGE()
- DALLE 2 and DALLE 3 for creation images
- GPT-4-Vision recognition images

GPT for Google Sheets™ (GPT-4o, GPT-3 Turbo, GPT-4, GPT-4-Turbo, GEMINI, CLAUDE, MISTRAL, PERPLEXITY)  includes built-in functions designed for working with AI, specifically tailored for GPT-4o. Add-on creates several "GPT" functions that can be used within any cell to access OpenAI's language models, including GPT-4o, ChatGPT-3, ChatGPT-4, Claude, Gemini, Perplexity and even the DALL-E 2 image generation model.

🔹 NEW! Added integration with GPT-4o

🔹 NEW! Added integration with Perplexity.ai

🔹 NEW! =SERP("What titles are used by my competitors?", 10) - getting list of titles, links, meta description, position for your search request

🔹 NEW! =GPT_IMAGE() - GPT-4 Turbo with Vision allows the model to take in images and answer questions about them.

🔹 NEW! Apr 23
=WEB_URL("https://docgpt.ai")
=WEB_TITLE("https://docgpt.ai")
=WEB_DESCRIPTION("https://docgpt.ai")
=WEB_H1("https://docgpt.ai")
=WEB_H2("https://docgpt.ai/")
=WEB_HEADINGS("https://docgpt.ai")
=WEB_PARAGRAPHS("https://docgpt.ai")
=WEB_URLS_DATA(A37:A39)


OpenAI:
- gpt-4o
- gpt4-vision
- gpt-4
- gpt-4-turbo
- gpt-3 turbo

Claude:
- claude-3-5-sonnet
- claude-3-opus
- claude-3-sonnet
- claude-3-haiku

Perplexity:
- llama-3-sonar-small-32k-chat
- llama-3-sonar-small-32k-online
- llama-3-sonar-large-32k-chat
- llama-3-sonar-large-32k-online


Mistral:
- Mistral 7B
- Mixtral 8x7B
- Mixtral 8x22B

Gemini:
- gemini-1.5-pro
- gemini-1.5-flash
- gemini-1.0-pro
- gemini-pro-vision
- text-embedding-004

AI Models: gemini (Bard), Anthropic (claude), Perplexity, Mistral, OpenAI, Anthropic (claude)

NOTE:  If you encountered issue such as:
🔹not being able to display the add-on's menu
🔹the add-on's sidebar appearing blank
🔹not being able to install the add-on
Most likely because you have multiple Google accounts logged into your browser. You need to Log out from all the accounts in your browser and only log in to the one you want to use with our add-on.

🔹 If you encounter the error message 'ScriptError: Authorization is required to perform that action' or any other error:

- Use personal google account
- You used multiple Google accounts in the same Chrome session, please create a new browser profile and log in again
- Ask admin of your workspace account to allow execute add-on

Troubleshooting: https://docgpt.ai/support/

How to use GPT for Sheets (Video): https://www.youtube.com/watch?v=Bn6UzkrCaBs

How to use GPT for Docs, Slides, Forms (Video): https://youtu.be/JBX45eiqe0w


GPT for Docs™ (DocGPT) is an AI-powered writing assistant designed to help professionals generate high-quality, error-free content quickly and efficiently. The tool is fully integrated with Google Docs™ and Sheets™, making it easy to use and accessible to anyone with a Google account.

If you encounter the error message 'ScriptError: Authorization is required to perform that action' or any other error:

- Use personal google account
- Ask admin of your workspace account to allow execute add-on

Troubleshooting: https://docgpt.ai/support/


🛠️ 🛠️ 🛠️  We do not require your OpenAI API key for ChatGPT. 

Please be aware that if you experience any of the following issues:

🚫 Unable to display the menu for the add-on
📝 The add-on's sidebar appearing blank
🛠️ Difficulty installing the add-on
This could be due to having multiple Google accounts logged into your browser. To resolve this, please log out of all accounts in your browser and sign in only with the one you intend to use with our add-on.


✅ Getting Started

To get started with DocGPT, follow these steps:

1. Install the add-on
2. Open Google Docs or Sheets
3. Go to Extensions -> GPT for Sheets, Docs, Slides, Forms-> 🚀 Launch


Try Also: AI Email Assistant: https://docgpt.ai/ai-email-assistant/

🔍 This add-on will help you achieve some tasks such as:
- generate blogposts ideas
- generate a book 
- generate an essay
- generate a course
- writing whole paragraphs or procedures
- cleaning up lists of names, adresses, emails or companies
- classifying lists of reviews with sentiment analysis or feature categorization
- summarizing reviews
- writing responses to online comments
- trying different versions of a prompt quickly
- working on ad copy (PPC, Google ads, Facebook ads)
- working on SEO metadata (titles, descriptions)
- working on landing page copy
- managing and cleaning product catalogs for e-commerce stores (Shopify and Amazon)
- translations

📄 GPT for Sheets, Docs:
- outlining a piece of content
- expanding a piece of content
- writing emails or blogs
- summarizing notes
- translating content
- changing the style of content

Use SheetGPT to perform such tasks as measuring the sentiment of your organization's mentioned tweets, creating social media content, writing press releases, extracting data, and anything else you could ask the world's most advanced AI to do for you.

📝 Advanced Language Generation Technology

One of the key features of GPT for Google Sheets and GPT for Google Docs, Slides, Forms is its advanced language generation technology, which allows it to generate content that is both natural and human-like. It can help you write an email, a report, or a blog post, tailored to your needs, and supports 26+ languages.

🎬 Write Scripts for Video Platforms

DocGPT can also be used to write scripts for video platforms such as YouTube and TikTok. It can assist you in generating catchy and engaging scripts that align with your brand and target audience, making it an ideal tool for digital marketers and content creators.

📊 Streamline Your Workflow

In addition to its writing capabilities, DocGPT also offers a range of features to help you streamline your workflow and complete repetitive tasks more efficiently. With DocGPT, you can easily format documents, add and update data, and schedule reminders and due dates.

🔍 Optimize Your Content for SEO

DocGPT also offers an excellent opportunity to optimize your content for SEO. It can generate keyword-rich content that can help improve your search engine rankings and increase visibility. DocGPT's ability to analyze your content and suggest keywords and phrases that align with your topic makes it an ideal tool for SEO optimization.

Updates:
---------------
-> Updated to new GPT-4-turbo model

20 FEB:
-> Add new functions GPT_LIST,  GPT_HLIST,  GPT_SPLIT, GPT_HSPLIT, GPT_APPLY, fix GPT_TABLE

7 FEB:
-> Improve using GPT-4 AI model - GPT for Sheets

20 NOV:
-> Improve data quality for GPT_TABLE function

15 NOV:
-> Improve Caching strategy

25 SEP:
-> Add caching for Sheets 

17 SEP:
-> Update tutorial links

9 SEP:
-> Support Google Forms
-> Support Google Slides

24 AUG:
-> Added various English language dialects: 
+ American
+ British
+ Australian

21 AUG:
-> Add "Continue writing" feature
-> Improve UI styles

20 AUG:
-> Improve UI

17 AUG:
-> Added Portugal (European),  Portugal (Brazil) and Catalan languages

22 June:
-> Add supporting more 10 languages (Swedish, Norwegian, Indonesian, Vietnamese, Chinese, Thai, Hebrew, Hindi, Hungarian, Filipino, Finnish, Czech, Danish)

4 June:
-> Summarize the text (Google Docs)
-> Summarize the text in bullet points (Google Docs)
-> Correct/Re-write the text to native speaker (any language)

1 May:
-> Support Google Sheets™

20 March:
-> Support languages: English, Spanish, French, German, Chinese (Mandarin), Arabic, Russian, Portuguese, Italian, Japanese, Korean, Dutch, Polish, Swedish, Danish, Norwegian, Finnish, Greek, Hindi, Bengali, Tamil, Telugu, Malayalam, Kannada, Marathi, Gujarati, Punjabi, Urdu, Persian (Farsi), Turkish, Indonesian, Thai, Vietnamese, Tagalog, Swahili, Romanian, Hungarian, Czech, Slovak, Slovenian, Croatian, Serbian, Bulgarian, Ukrainian, Icelandic, Latin, Esperanto, and Klingon

19 March:
-> Support ChatGPT4 (gpt4, chat gpt)

12 March:
-> Add emojis to the text
-> Rephrase the text
-> Use ChatGPT-3.5 OpenAI (gpt3, chat gpt, chatgpt)

👨‍💼 For Busy Professionals and Students

Whether you're a busy professional looking to save time or a student looking for a reliable writing assistant, DocGPT is the perfect tool for you. It offers a range of features and capabilities that make it easy to generate high-quality content and stay organized.


Alternatives to make.com, zapier.com, ahref, Talarian (talarian.io), Sheets Magic, GPT for Work (gptforwork.com), awesome table, Copy.AI, Anyword, Frase.io, Scalenut, Grammarly Business, Writesonic, Jasper, Rytr, Pepper Content.


Overall, GPT for Google Docs™ and Sheets™ is a valuable addition to any professional's workflow. It's an easy-to-use, versatile, and powerful tool that can help you save time, improve your writing skills, and optimize your content for SEO. Google Docs™, Sheets™ is a trademark of Google LLC.

👍 Try also:
Google Doc AI: https://docgpt.ai/google-doc-ai/
GPT for Sheets: https://docgpt.ai/quiz-maker-ai/
Google Slides AI: https://docgpt.ai/google-slide-ai/

GPT for Docs, Sheets, Slides, Forms - Add-Ons: https://docgpt.ai/