Support Center

Find answers fast

Search across GSheetPress guides, or choose a topic from the sidebar.

🚀Getting Started

How to install the GSheetPress add-on

+
  1. Open any Google Sheet.
  2. Click Extensions → Add-ons → Get add-ons.
  3. Search for "GSheetPress" or "GS2Web SaaS".
  4. Click Install and grant the required permissions.
  5. Refresh your Sheet. GSheetPress now appears under Extensions → GSheetPress.
Tip: You only need to install the add-on once. It'll be available in all your Google Sheets automatically.

Creating your first tool — a quick overview

+

GSheetPress turns Google Sheets into four types of web tools:

  • Calculator — interactive calculators using Sheets formulas (mortgage, BMI, pricing, ROI).
  • Table — live, searchable data tables with sorting, filtering, and conditional formatting.
  • Chart — interactive bar, line, pie, doughnut, radar, and scatter charts from your data.
  • Shop — mobile-first product grids with buy buttons linking to any checkout.

For each tool, the process is the same: design your data in a Google Sheet, open the GSheetPress add-on, configure a few settings, and click Publish. You get an embed code you can paste on any website.

Publishing and embedding on your website

+

After clicking Publish in the add-on, your tool gets a unique URL and an embed code. To embed:

  1. Go to your Dashboard and find your tool.
  2. Click Get Links or copy the embed code.
  3. Paste the <iframe> code into your website's HTML.

Platform-specific tips:

  • WordPress: Use the Custom HTML block in Gutenberg, or the HTML widget in Classic editor.
  • Wix: Add an "Embed a site" element and paste the URL.
  • Shopify: Edit the page/product template and add a Custom Liquid section with the iframe.
  • Squarespace: Use a Code Block and paste the iframe code.

Understanding the free trial

+

Every new account gets a 7-day free trial with no credit card required. During the trial you can create and publish calculators, tables, and shops with full feature access.

Each product has its own trial — Calculator (2 calculators), Table (1 table, 200 rows), Chart (1 chart), and Shop (1 shop, 10 products). When the trial expires, your published tools stay online but become read-only. Upgrade any product independently to resume editing.

How to update a published tool

+

Edit your Google Sheet as usual — change values, add rows, update formatting. Then open the GSheetPress add-on and click Publish again. The embed URL stays the same, so your website automatically shows the updated version. No code changes needed on your site.

Tip: Published tables and shops may be cached for up to 5 minutes. If you don't see changes immediately, wait a few minutes and refresh.
🧮Calculator

How to create a web calculator

+
  1. Open a Google Sheet and design your calculator with input cells (what the user fills in) and output cells (results calculated by formulas).
  2. Open Extensions → GSheetPress → New Calculator.
  3. The add-on opens a sidebar. Select which cells are inputs and which are outputs.
  4. Choose a theme, set the title, and click Publish.
  5. Copy the embed code from your Dashboard and paste it on your website.

All standard Google Sheets formulas work — SUM, IF, VLOOKUP, INDEX/MATCH, ARRAYFORMULA, and more. GSheetPress captures the computed output, not the raw formula.

Calculator themes and customization

+

GSheetPress includes 5 modern themes for calculators. Select a theme when publishing — it controls colors, fonts, spacing, and the overall look. All themes are fully responsive and mobile-friendly.

You can also include graphs and charts in your calculator output. If your Google Sheet has a chart, it can be embedded alongside the calculator results.

Lead capture and email-gated results

+

On the Starter and Pro plans, you can require visitors to enter their email address before seeing calculator results. This turns your calculator into a lead generation tool.

When enabled, the calculator shows input fields normally but hides the output until the visitor provides their email. The email is saved to your Google Sheet automatically.

Note: Email Lock is not available on the Free or Starter plan. Upgrade to Pro for this feature.

PDF download and emailing results

+

Calculators can generate a downloadable PDF of the results. Visitors click a button, and a formatted PDF is created and downloaded instantly. You can also configure the calculator to email results to the visitor automatically.

These features are useful for mortgage calculators, quote generators, and ROI tools where users want to save or share their results.

Which Google Sheets formulas are supported?

+

All of them. SUM, IF, VLOOKUP, INDEX/MATCH, ARRAYFORMULA, IMPORTRANGE, QUERY, and every other Google Sheets function works because GSheetPress reads the computed cell values — not the formulas themselves.

Live functions like =TODAY() or =GOOGLEFINANCE() are captured at publish time. To refresh these values, simply re-publish from the add-on (one click).

📊Table

How to create a data table

+
  1. Open a Google Sheet with your data. The first row should be headers (column names).
  2. Open Extensions → GSheetPress → New Table.
  3. Configure settings — choose a theme, set title, select display options.
  4. Click Publish.
  5. Copy the embed code from your Dashboard.

Your table is now live, searchable, sortable, and fully responsive. Visitors can search across all columns, click headers to sort, and paginate through large datasets.

Conditional formatting on the web

+

GSheetPress preserves your Google Sheets conditional formatting on the web. Threshold rules (greater than, less than, between) and gradient/color-scale rules both render in the published table.

This is ideal for dashboards, scorecards, inventory trackers, and budget tables where red/amber/green color signals carry meaning. The formatting updates every time you re-publish.

Supported: Threshold rules, gradient scales, featured column highlighting. Coming soon: Custom formula-based rules (=AND(...) style).

Rich interactive cells — links, images, video, maps

+

Table cells can render as more than plain text. GSheetPress automatically detects and renders:

  • Links — URLs become clickable links.
  • Images — image URLs render as inline images.
  • YouTube videos — YouTube links embed as playable video.
  • Google Maps — address links render as map embeds.
  • Star ratings — numeric values display as star icons.
  • Progress bars — percentages render as visual bars.
  • QR codes — auto-generated for sharing.

These are detected from your cell data automatically — no special configuration needed.

Playing audio files in table cells

+

Table cells can play audio files directly. Paste an audio URL into any Google Sheets cell, and it renders as a compact ▶ play button with a progress bar and duration.

Supported formats: .mp3, .wav, .ogg, .m4a, .aac, .webm, .flac

How it works:

  • Paste a direct URL to an audio file in any cell (e.g. https://example.com/audio.mp3).
  • Publish your table — the URL automatically becomes a play button.
  • Visitors click ▶ to play, click again to pause.
  • Only one audio plays at a time — starting a new one stops the previous.

Where to host audio: Firebase Storage, Google Drive (with sharing link), Dropbox, Amazon S3, or any server that serves direct file URLs.

Tip: This is great for podcast directories, music libraries, language courses, and sample audio catalogs.

Search, sort, and pagination

+

Every published table includes built-in interactivity:

  • Global search — a search box filters across all columns instantly.
  • Click-to-sort — click any column header to sort ascending/descending.
  • Smart pagination — large tables are split into pages for fast loading.

These features work automatically. No configuration needed — they're part of every published table.

SEO: Making your table visible to Google and AI engines

+

Unlike plain iframe embeds, GSheetPress tables are server-rendered. This means Google, ChatGPT, Perplexity, Claude, and other AI engines can read your table data directly.

To improve your table's ranking, use the SEO Content Editor in your Dashboard to add:

  • Introduction — 2–3 sentences explaining what the table shows.
  • Key Takeaways — 3–5 bullet-point insights from your data.
  • FAQs — 3–5 questions your table answers.
  • Summary — a concluding paragraph AI engines can cite.

These sections appear on your published table page automatically with matching schema.org structured data.

Monetizing your table with Stripe (Pro)

+

On the Pro plan, you can lock a table behind a Stripe payment. Visitors pay you directly through your own Stripe account — GSheetPress takes no commission.

Set up your Stripe keys in Dashboard → Payment Settings, then enable monetization for any table. Visitors see a preview, and the full table unlocks after payment.

📊Chart

How to create an interactive chart

+
  1. Put your data in a Google Sheet — row 1 should be headers (these become labels and legend entries).
  2. Open Extensions → GSheetPress → 📊 Chart → New Chart.
  3. In the sidebar, pick your chart type (bar, line, pie, doughnut, radar, scatter).
  4. Select the Labels column (X-axis — e.g. months, categories) and one or more Data columns (Y-axis — e.g. revenue, costs).
  5. Choose a color theme, toggle legend and grid options, and optionally add highlights, annotations, tooltip formatting, or live sync.
  6. Click Publish Chart.

You'll get a stable URL and a responsive iframe embed code. Paste the embed code on any website. When you republish the same chart, the URL stays the same.

Chart types explained

+

GSheetPress supports 7 chart types:

  • Bar (Vertical) — compare values across categories. Best for: sales by region, survey responses.
  • Bar (Horizontal) — same but horizontal. Best for: long category labels, rankings.
  • Line — show trends over time with smooth curves. Best for: monthly revenue, growth data.
  • Pie — show proportions of a whole. Best for: market share, budget breakdown.
  • Doughnut — like pie with a hollow center. Modern look for the same data.
  • Radar — compare multiple variables on radial axes. Best for: skill comparisons, product ratings.
  • Scatter — plot individual data points. Best for: correlations, distributions.

All types support multiple data series (select more than one data column), stacking (toggle in sidebar), formatted tooltips, highlights, exports, and all color themes.

Chart themes and custom styling

+

Choose from 6 professionally designed color palettes:

  • Default (Purple) — GSheetPress brand colors. Professional and modern.
  • Ocean (Blues) — cool blue tones. Great for corporate and tech sites.
  • Sunset (Warm) — orange, red, and pink. Eye-catching and energetic.
  • Forest (Greens) — green palette. Perfect for sustainability and nature topics.
  • Monochrome (Grays) — grayscale. Elegant, minimal, matches any design.
  • Vibrant (Mixed) — bold rainbow colors. Maximum visual impact.

You can also customize the chart background, text color, grid color, highlight color, and legend position from the Chart sidebar. These settings are saved with the chart and apply wherever the chart is embedded.

Responsive embeds, auto-height, and dark mode

+

After publishing, you get an iframe embed code that works on any website — WordPress, Wix, Squarespace, Shopify, or custom HTML.

Dark mode: Add ?theme=dark to the chart URL for a dark background. Example:

<iframe src="https://gsheetpress.com/chart.html?id=123&theme=dark"></iframe>

Charts are fully responsive — they resize on mobile, tablet, and desktop. New embed codes also include automatic height messaging, so the iframe can grow when insights or legends need more room.

Updating chart data and stable URLs

+

Charts update when you re-publish from the add-on. Change your Google Sheets data, then open the GSheetPress add-on and click Publish Chart again. The embed URL stays the same.

Multiple data series: Select two or more data columns when creating the chart. Each column becomes a separate series with its own color from your chosen theme. This works with bar, line, and radar charts. For pie and doughnut, one data column is best.

Stacked mode: Toggle "Stacked" in the sidebar to stack bar or line series. Useful for showing how parts contribute to a total over time.

Annotations, highlights, and shaded ranges

+

Charts can include context layers such as highlighted data points, selected bars, threshold lines, shaded time ranges, and text notes. In the Chart sidebar, use Highlight Rows for quick point/bar highlights, or add advanced annotations as JSON.

Example annotation JSON:

[{"type":"point","label":"Peak","x":"June","y":120},{"type":"box","label":"Campaign","xMin":"March","xMax":"April"}]

Supported annotation types include point, line, box, and text. This makes charts easier to explain, especially for reports, editorial graphics, and dashboards.

Custom tooltip formatting

+

Tooltips appear when visitors hover or tap chart data. You can customize the tooltip prefix, suffix, and decimal places from the Chart sidebar.

  • Use a prefix like $ for revenue or cost charts.
  • Use a suffix like %, kg, or users.
  • Set decimals to control whether values appear as 12, 12.3, or 12.34.

This keeps chart labels clean while still showing exact values on interaction.

Exporting charts as PNG or PDF

+

Published charts include export buttons for PNG and PDF. PNG is useful for images, reports, and social sharing. PDF is useful for presentations, client reports, and saved analysis.

Exports are generated in the visitor's browser from the rendered chart. This keeps export fast and avoids exposing private spreadsheet data beyond what is already visible in the chart.

Automatic chart insights

+

When a chart is published, GSheetPress generates basic deterministic insights such as the highest value, lowest value, average, and change across the series. These appear below the chart when available.

These insights do not require AI or an API key. They are calculated directly from the chart data and update when you republish or live-sync the chart.

AI chart recommendation and AI insights

+

Chart AI can recommend the best chart type, title, label column, data columns, insights, and suggested annotations based on your data.

  1. Open Extensions → GSheetPress → Chart → AI Settings.
  2. Add your own Claude or OpenAI API key in the Chart Settings sheet.
  3. Run AI Recommend Chart for setup guidance, or AI Generate Insights after publishing a chart.
Privacy note: Your API key is not published with the chart. It is sent only when you run an AI action.

Google Sheet live sync

+

Live Sync lets a chart update from Google Sheets without manually republishing every time.

  1. In the Chart sidebar, turn on Live Sync before publishing.
  2. Open Extensions → GSheetPress → Chart → Enable Live Sync once for the spreadsheet.
  3. When the sheet changes, GSheetPress refreshes live-sync charts and the public embed listens for the updated data.

You can also run Sync Charts Now from the Chart menu to manually refresh all live-sync charts in the current spreadsheet.

🛍️Shop

How to create a product shop

+
  1. Open a Google Sheet and go to Extensions → GSheetPress → New Shop.
  2. A pre-formatted sheet appears with columns: Title, Image URL, Description, Price, Buy URL (plus optional Badge, Old Price).
  3. Fill in your products — one row per product.
  4. Paste your checkout link (Shopify, Stripe, Razorpay, or WhatsApp) in the Buy URL column.
  5. Click Publish and embed on your website.

Your shop renders as a beautiful, mobile-first 2-column product grid with buy buttons.

Setting up checkout links

+

GSheetPress does not process payments. The Buy button on each product links to whatever URL you put in the Buy URL column. This can be:

  • Shopify — your product page URL or cart permalink.
  • Stripe — a Stripe Payment Link (e.g. https://buy.stripe.com/...).
  • Razorpay — a Razorpay Payment Link.
  • WhatsApp — a https://wa.me/PHONE?text=ORDER link for chat-based ordering.
  • Any URL — any checkout page from any platform.

You keep 100% of revenue. GSheetPress never touches the money.

Uploading product images

+

You can upload product photos directly in your GSheetPress dashboard:

  1. Go to Dashboard → Shop → Upload Images.
  2. Drag and drop images or click to upload (JPG, PNG, or WebP, max 2 MB each).
  3. Click Copy URL on any uploaded image.
  4. Paste the URL into the Image URL column of your shop sheet.

Images are hosted on Firebase Storage within your plan's quota (10 MB free, 100 MB Starter, 500 MB Pro). Square images work best for the product grid.

Shop setup — banner, tagline, contact, and pretty URL

+

In Dashboard → Shop → My Shops, select your shop to configure:

  • Banner image — a wide image shown across the top of your shop.
  • Tagline — a short line under your shop name (e.g. "Handmade ceramics, shipped worldwide").
  • Contact info — phone, WhatsApp, email, and address. These appear as a floating contact button on your shop page.
  • Shop link — a pretty URL like gsheetpress.com/s/your-shop-name for sharing.
  • Analytics — add your Google Analytics (GA4) or Meta Pixel ID to track visitors.
Note: Your shop must be published from the add-on before you can set a pretty link. If you see "not published," go to Google Sheets and click Publish first.

Badges and sale prices

+

You can highlight products with badges and sale pricing directly from your sheet:

  • Badge column — enter "New", "Hot", "Sale", or any short label. It appears as a tag on the product image.
  • Old Price column — enter the original price. It renders as a strikethrough next to the current price (e.g. $59 $49).

Both columns are optional. Leave them blank for products without badges or discounts.

🌐Website / Blog

What is SheetBlog and what can I build with it?

+

SheetBlog turns a Google Sheet into a live blog, magazine, knowledge hub, or simple content website. You do not need WordPress, a theme builder, hosting setup, or coding. Your sheet becomes the content management system.

Each row in the SheetBlog sheet becomes one public article. The columns control the article title, URL slug, image, category, content, author, date, SEO title, FAQ, tags, and publish status.

Good uses for SheetBlog:

  • Company blog — publish announcements, tutorials, and product updates.
  • Magazine homepage — show a featured story, side stories, latest posts, and categories.
  • Knowledge hub — organize practical guides, FAQs, and answer-focused articles.
  • Directory magazine — combine articles with live tables, charts, calculators, and shop embeds.
  • SEO content website — create article pages with clean URLs, sitemap, RSS, schema, and social cards.
Result: If you can fill rows in a spreadsheet, you can manage a content website.

How to create your first SheetBlog website

+
  1. Open a Google Sheet.
  2. Go to Extensions → GSheetPress → SheetBlog → New SheetBlog.
  3. Enter a name for your blog or website, such as AI Tools Weekly or My Company Blog.
  4. GSheetPress creates a ready-made SheetBlog sheet with article columns and one example row.
  5. Edit the example row or add a new row. Fill at least Title, Slug, Category, Excerpt, Content, Date, and Status.
  6. Set Status to Publish for articles that should go live.
  7. Go to Extensions → GSheetPress → SheetBlog → Publish SheetBlog.
  8. Open the SheetBlog Link sheet to copy your homepage, RSS, sitemap, and admin links.
Important: Publish from the SheetBlog sheet itself. If another tab is selected, the add-on may ask you to select a SheetBlog sheet first.

SheetBlog column guide — what to put in each column

+

Keep the default column names for best results. Here is what each important column does:

  • Title — the article headline shown on the homepage and article page.
  • Slug — the article URL text, such as best-ai-tools. Use lowercase words separated by hyphens.
  • Category — groups posts into category pages, such as Guides, News, Reviews, or Tutorials.
  • Image — the featured image URL. Use a clear, relevant image.
  • Image Alt — short image description for accessibility and SEO.
  • Image Credit and Image Source URL — credit the image source when required.
  • Excerpt — a short summary shown on the homepage cards.
  • Content — the full article body.
  • Author — writer name shown on the article.
  • Date — article publish date.
  • Status — choose Publish or Draft.
  • Featured — tick the checkbox to make a post appear as a hero/editor pick.
  • SEO Title — custom search result title. Keep it clear and under about 60 characters.
  • SEO Description — custom search/social description. Keep it useful and under about 155 characters.
  • Direct Answer — one clear answer paragraph for AI search and featured snippets.
  • TLDR — short key points separated by semicolons.
  • FAQ — one question and answer per line using Question | Answer.
  • Sources — source links separated by comma, semicolon, or new line.
  • Tags — topic keywords separated by comma. Tags help discovery, and tag pages are noindex by default to reduce duplicate-content risk.

How to format article content without coding

+

Write inside the Content column using simple plain-text formatting. You do not need HTML.

Use this format:

  • ## Main section heading creates a large heading.
  • ### Subheading creates a smaller heading.
  • - Bullet point creates a bullet list.
  • 1. Step one creates a numbered list.
  • > Important quote creates a quote block.
  • **important text** makes text bold.
  • *emphasized text* makes text italic.
  • [link text](https://example.com) creates a clickable link.

Recommended article structure:

  1. Start with 2-3 short paragraphs explaining the problem and promise.
  2. Add a Direct Answer in its own column for answer engines.
  3. Use ## headings for major sections.
  4. Use bullets or numbered steps when teaching a process.
  5. Add examples, source links, and a short FAQ.
  6. End with a practical next step.
Best practice: Keep paragraphs short. One idea per paragraph is easier for readers, Google, and AI answer engines.

Draft, Publish, Featured, update, and delete behavior

+

The Status column decides whether a row is public.

  • Publish — the article appears on the homepage, category pages, sitemap, RSS feed, and its own URL.
  • Draft — the article stays inside your Google Sheet and is not shown publicly.

Use Draft for unfinished articles, AI-created drafts, future ideas, or private notes. Use Publish only when the content is ready for visitors.

The Featured checkbox tells SheetBlog which article should receive extra homepage attention. Featured posts can appear in the hero or editor-pick areas depending on the layout.

To update an article, edit the row and click Publish SheetBlog again. The article URL stays the same as long as the slug stays the same.

To remove an article from the public site, either set Status to Draft and republish, or delete the row and republish.

Homepage, categories, menu, logo, and search

+

SheetBlog automatically creates a magazine-style homepage from your published rows. You get:

  • A hero featured post.
  • Side stories and latest posts grid.
  • Category links based on your Category column.
  • Live search on the homepage.
  • Article pages with clean URLs.
  • Mobile-friendly layout for phones and tablets.

Use the SheetBlog Menu sheet to control the top menu and branding:

  • Label — menu item text, such as Home, About, Contact.
  • URL — use home for the homepage, a full URL, or a path like /pricing.html.
  • Order — smaller numbers appear first.
  • Show — tick the checkbox to display the menu item.
  • Badge — optional label such as New, Hot, Sale, or Updated. It appears as a small blinking label beside the menu item.
  • Logo setting — paste a logo image URL. SheetBlog renders it in the header at about 64 x 54 px.
  • Blog Title and Description — control the public brand title and homepage intro.
Tip: Keep menu labels short on mobile, such as Home, Guides, About, Contact. For category dropdowns or larger menus, use the Mega Menu options described below.

Creating category menus, mega menus, and New/Hot badges

+

The SheetBlog Menu sheet controls your website's top navigation. It is designed to be simple like a spreadsheet, but flexible enough for blog and magazine websites.

Basic menu columns:

  • Label — the visible menu text, such as Home, Categories, Tools, About.
  • URL — where the menu item goes.
  • Order — smaller numbers appear first.
  • Show — tick the checkbox to show the item.
  • Badge — optional small label such as New, Hot, Sale, Free, or Updated.

Common URL values:

  • home — links to the SheetBlog homepage.
  • categories — creates an automatic mega menu using your article categories.
  • /pricing.html — links to a GSheetPress page path.
  • https://example.com/about — links to any full external URL.

Automatic category mega menu:

Use this row:

Label = Categories
URL = categories
Show = TRUE

SheetBlog automatically lists your published categories in a dropdown/mega menu.

Custom mega menu:

Use mega: in the URL column, followed by menu items in this format:

mega:AI Tools|/b/myblog/category/ai-tools; Calculators|/calculator-details.html; Contact|https://example.com/contact

Each item uses Label|URL. Separate multiple items with semicolons.

Menu badges:

In the Badge column, type New, Hot, Sale, Free, or any short word. SheetBlog shows it as a small blinking label beside the menu item.

After editing menu rows: click SheetBlog → Publish SheetBlog. Menu changes are published only after republishing.

Changing your SheetBlog design with Themes

+

SheetBlog includes prebuilt website themes so different sites do not all look the same. A food blog, finance website, tech blog, local business site, and knowledge hub can each have a different visual style while still using the same Google Sheet workflow.

To apply a theme:

  1. Open your SheetBlog Google Sheet.
  2. Go to Extensions → GSheetPress → SheetBlog → Themes.
  3. A right sidebar opens with visual preview cards.
  4. Click Apply on the theme you want.
  5. The theme settings are saved into the SheetBlog Menu sheet.
  6. Click SheetBlog → Publish SheetBlog to update the live website.

Available theme presets:

  • Editorial Magazine — best for news, analysis, opinion, and thought leadership.
  • Food & Recipe — best for recipes, cafes, restaurants, and lifestyle stories.
  • Finance & Data — best for markets, money, reports, and data-backed advice.
  • Tech Blog — best for SaaS, AI tools, startups, and product updates.
  • Knowledge Hub — best for guides, FAQs, documentation, and educational hubs.
  • Local Business — best for agencies, services, clinics, and local company websites.

A theme applies to the whole website, not to one article row. Your article rows remain focused on content: title, image, article text, SEO, status, and category.

You can still manually edit these settings in the SheetBlog Menu sheet after applying a theme:

  • Theme
  • Primary Color
  • Accent Color
  • Font Style
  • Hero Style
  • Card Style
Tip: For most users, the easiest workflow is choose a theme, add your logo, edit Blog Title and Description, then publish. Agencies can use themes as a fast starting point and adjust colors for each client.

SEO and AEO setup for SheetBlog articles

+

SheetBlog is built for search engines and answer engines. When you publish, GSheetPress creates article pages with SEO-friendly URLs, canonical URLs, meta titles, descriptions, social cards, BlogPosting schema, sitemap, and RSS.

For best results, fill these columns for every important post:

  • SEO Title — write the title a searcher would click.
  • SEO Description — summarize the article benefit clearly.
  • Direct Answer — answer the main question in 40-80 words.
  • TLDR — 3-5 short takeaways separated by semicolons.
  • FAQ — add real user questions in Question | Answer format.
  • Sources — add trustworthy source links when the article makes claims.
  • Updated date — if you add an Updated column, SheetBlog can use it as the modified date.

Good Direct Answer example: "SheetBlog is a no-code website builder that uses Google Sheets as the CMS. Each row becomes one article, and GSheetPress automatically creates the homepage, article URLs, categories, sitemap, RSS feed, schema, and mobile layout."

Avoid: Do not create many thin articles that repeat the same content. Write each article to answer a specific question or solve a real problem.

Writing FAQs, date/time, and related articles correctly

+

The FAQ column can contain more than one question and answer for the same article. The easiest method is one question-answer pair per line inside the same cell.

Recommended FAQ format:

What is SheetBlog? | SheetBlog turns Google Sheets rows into articles.
How do I publish? | Set Status to Publish and click Publish SheetBlog.
Can I add videos? | Yes, use YouTube or Vimeo shortcodes in the Content column.

To add a new line inside one Google Sheets cell:

  • Mac: press Option + Enter.
  • Windows: press Alt + Enter.

You can also separate FAQs with ;; if line breaks are difficult:

Question one? | Answer one. ;; Question two? | Answer two.

Date and time:

SheetBlog shows the date/time as written by the author in the Google Sheet. This prevents unwanted date changes caused by server timezone differences. Use a clear format such as:

  • 2026-06-27 10:30 AM
  • 27/06/2026 10:30 AM
  • Jun 27, 2026 10:30 AM

Related articles:

Single article pages automatically show related articles below the article. SheetBlog first looks for posts in the same category, then fills remaining spots with recent published articles. You do not need to configure this manually.

Sidebar search:

Single article pages include a search field above the sidebar list so visitors can quickly find another article.

Images, alt text, and photo credits

+

Every post can have a featured image. Paste the image URL in the Image column.

Recommended image practices:

  • Use images that clearly match the article topic.
  • Prefer landscape images for article covers.
  • Fill Image Alt with a simple description, such as "Google Sheet used as a blog content calendar".
  • Fill Image Credit and Image Source URL if the image provider requires credit.
  • Avoid huge image files. Large images can make pages slower on mobile.

If you use SheetBlog AI image search, add your own Unsplash, Pixabay, or Pexels API key in the SheetBlog Menu settings. The image URL and alt text can then be filled automatically.

Embedding tables, calculators, charts, and shops inside articles

+

SheetBlog can include live GSheetPress products inside an article. This is useful when your article needs supporting data, calculators, product lists, or charts.

Use these shortcodes inside the Content column:

  • [table:TABLE_ID] embeds a published table.
  • [calculator:CALCULATOR_ID] embeds a published calculator.
  • [chart:CHART_ID] embeds a published chart.
  • [shop:shop-slug] embeds a published shop by slug.
  • [table-slug:table-slug] embeds a table/shop page by slug.

You can copy these from the product link sheets created by the add-on, such as Table Link, Calculator Link, and Chart Link.

Example article use: Write a buying guide, then insert a live comparison table after the introduction. Or write a finance article, then insert a calculator inside the "Estimate your cost" section.

Tip: Place embeds after a short explanation so visitors understand what they are looking at.

Adding YouTube or Vimeo videos to an article

+

Paste a video shortcode into the Content column where you want the video to appear.

YouTube:

[youtube:https://www.youtube.com/watch?v=VIDEO_ID]

Vimeo:

[vimeo:https://vimeo.com/VIDEO_ID]

After publishing, SheetBlog turns the shortcode into a responsive video embed. It works on desktop and mobile.

Best practice: Add one or two sentences before the video explaining why the reader should watch it. Search engines cannot understand a video as well as written context.

Using AI to create article rows and images

+

SheetBlog AI is designed for individual users who own their API keys. Your keys are entered in the SheetBlog Menu settings area and are used only when you run an AI action from your spreadsheet.

Available AI actions may include:

  • Generate Ideas — creates blog topic rows.
  • Draft Article — writes a complete article row as Draft.
  • Improve Selected Row — improves formatting, SEO, FAQ, Direct Answer, TLDR, and tags.
  • Find Image for Selected Row — searches image providers and fills image URL, alt text, credit, and source URL.

AI provider order can be set as claude,openai or openai,claude. Image provider order can be set as unsplash,pixabay,pexels.

Important: AI-created rows should stay as Draft until you review facts, links, spelling, tone, image rights, and SEO fields.

Links, sitemap, RSS, sharing, mobile, and plan limits

+

After publishing, the SheetBlog Link sheet shows your important public links:

  • Homepage — your main blog website URL.
  • RSS — feed readers can follow your published posts.
  • Sitemap — search engines can discover article URLs.
  • Admin — dashboard link for SheetBlog management.
  • Status — shows whether the SheetBlog is active or deleted/not published.

SheetBlog also supports pagination after many posts, social share buttons on article pages, category pages, live search, mobile-friendly layouts, and iOS-friendly viewport behavior.

Free plans can have limits such as a maximum number of published posts and monthly human page views. If a free blog crosses the allowed post or traffic limit, visitors may see an upgrade prompt until the owner upgrades or reduces published posts.

For a custom domain, publish the SheetBlog first, then configure the domain from the GSheetPress dashboard when the feature is available for your plan.

Common SheetBlog problems and quick fixes

+

Problem: My article is not visible.

Check the Status column. It must be Publish. Then click Publish SheetBlog again.

Problem: The article URL changed.

The URL comes from the Slug column. Keep the slug stable after publishing. If you change it, the old article URL may stop working.

Problem: I deleted a SheetBlog but the link still appears.

Run SheetBlog → SheetBlog Link or publish/delete again after updating the add-on. Deleted blogs should disappear from active links or show as deleted/not published.

Problem: Images do not load.

Open the image URL in a browser. If it does not open publicly, use another public image URL or upload the image somewhere public.

Problem: Shortcode embed is blank.

Make sure the table, calculator, chart, or shop is already published. Copy the shortcode from the relevant Link sheet to avoid typing mistakes.

Problem: Menu or logo changes are not visible.

Edit the SheetBlog Menu sheet, then click Publish SheetBlog again.

💳Account & Billing

How plans work — independent product subscriptions

+

Each GSheetPress product has its own independent plan. There is no bundled subscription. You can be on Pro for Calculator, Starter for Table, and Free Trial for Shop — all at the same time.

This means you only pay for what you use. If you only need calculators, you only pay for the Calculator plan.

Plans per product:

  • Calculator: Free Trial → Starter ($9/mo or $60/yr) → Pro ($19/mo or $151/yr)
  • Table: Free Trial → Starter ($9/mo or $60/yr) → Pro ($19/mo or $151/yr)
  • Chart: Free Trial → Starter ($5/mo or $48/yr) → Pro ($11/mo or $99/yr)
  • Shop: Free Trial → Starter ($9/mo) → Pro ($19/mo)

Toggle between monthly and yearly pricing on any product page. Yearly plans save up to 44%.

See the Pricing page for full details.

How to upgrade your plan

+
  1. Go to Dashboard → Orders & Billing.
  2. Find the product you want to upgrade (Calculator, Table, Chart, or Shop).
  3. Click Upgrade and choose Starter or Pro.
  4. Complete the Stripe checkout. Your plan activates instantly.

You can also upgrade from any product's detail page on the website (Calculator, Table, Chart, Shop).

Cancelling your subscription

+

Go to Dashboard → Orders & Billing and click Cancel on the subscription you want to stop. Your plan remains active until the end of the current billing period — you won't lose access immediately.

After cancellation, your published tools stay online but become read-only. You can re-subscribe at any time to restore full access.

What happens when the trial expires?

+

When your 7-day trial expires:

  • Your published tools stay online and visitors can still see them.
  • You cannot publish new tools or update existing ones.
  • No data is deleted. Everything is preserved.
  • Upgrade to Starter or Pro at any time to resume full access.

Each product's trial is independent. Your Calculator trial can expire while your Table trial is still active.

Yearly billing — save up to 44%

+

All products offer yearly billing at a significant discount:

  • Calculator Starter: $9/mo → $60/yr (save 44%)
  • Calculator Pro: $19/mo → $151/yr (save 34%)
  • Table Starter: $9/mo → $60/yr (save 44%)
  • Table Pro: $19/mo → $151/yr (save 34%)
  • Chart Starter: $5/mo → $48/yr (save 20%)
  • Chart Pro: $11/mo → $99/yr (save 25%)

Toggle between monthly and yearly on any product page using the billing switch above the pricing cards. Yearly plans are billed once and last 12 months.

🔧Troubleshooting

My table or calculator isn't showing

+

If your embed shows a blank area or doesn't load:

  • Check the embed code — make sure the full <iframe> tag is pasted correctly, including the src URL.
  • Check your plan — if your trial or subscription has expired, the embed may not render. Log in to your Dashboard to check.
  • Try the direct URL — open the table/calculator URL directly in a browser. If it works there but not in the embed, the issue is with your website's iframe settings.
  • Clear cache — published tools are cached for up to 5 minutes. If you just re-published, wait and try again.

Formatting looks wrong or missing

+

If your cell colors, fonts, or conditional formatting aren't appearing in the published table:

  • Re-publish — formatting is captured at publish time. If you changed colors after publishing, click Publish again.
  • Check conditional formatting type — threshold rules and gradient scales are supported. Custom formula rules (=AND(...) style) are not yet supported.
  • Use the standard color picker — colors applied via Google Sheets' built-in color picker work. Custom hex colors in add-on themes may override them.

Table looks broken on mobile

+

GSheetPress tables automatically switch to a card layout on mobile screens. Each row becomes a card with the column headers as labels. This is the intended behavior for readability.

If the card layout isn't showing or text is cut off:

  • Make sure your iframe has width="100%" so it fills the available width.
  • Avoid setting a fixed height on the iframe — let it auto-size, or use a generous height like 800px.
  • If text is truncated, check that your cell content isn't excessively long (100+ characters per cell can overflow).

Shop pretty link redirects to the homepage

+

If your gsheetpress.com/s/your-shop URL redirects to the homepage, the slug wasn't saved correctly. To fix:

  1. Make sure the shop is published first from the Google Sheets add-on.
  2. Go to Dashboard → Shop → My Shops.
  3. Select the shop, enter the slug, and click Save shop setup.
  4. Watch for the "✓ Saved" message. If you see an error, the shop may not be published yet.
Important: The shop must be published from the add-on before a pretty link can be set. The save function checks that the shop exists in the published URL registry.

Add-on not showing in Google Sheets

+

If GSheetPress doesn't appear under Extensions:

  • Refresh the page — Google Sheets sometimes needs a reload to show newly installed add-ons.
  • Check installation — go to Extensions → Add-ons → Manage add-ons and verify GSheetPress is installed and enabled.
  • Try a different Sheet — open a new Google Sheet and check if the add-on appears there.
  • Re-install — if nothing works, uninstall and re-install from the Google Workspace Marketplace.

No articles match your search. Try different keywords or contact support.

Still need help?

Can't find what you're looking for? Our team responds within 24 hours.

Contact Support →