Powered by

# SheetPoet - Google Sheets WordPress Connector

SheetPoet is a powerful tool that connects Google Sheets directly to your WordPress site, allowing you to:

  • Import any WordPress data into Google Sheets
  • Update any WordPress content from Google Sheets
  • Execute custom WordPress functions from your spreadsheets
  • Automate any content workflows

Just like that. No complex integrations required. Define your own logic in functions in PHP and run them from Google Sheets.

# Overview

SheetPoet consists of two components:

  1. WordPress Plugin: Installed on your WordPress site
  2. Google Sheets Add-on: Installed in Google Sheets

Together, these components create a powerful bridge between your WordPress site and Google Sheets.

# Quick Start

Ready to get started? Our step-by-step guide will help you set up SheetPoet and run your first data exchange:

🚀 A Video Tutorial of full walkthrough
tutorial/

Getting Started Guide →

# Components

# WordPress Plugin

The WordPress plugin allows you to create custom functions, view execution history and generate API keys.

WordPress Plugin →

# Google Sheets Add-on

The Google Sheets add-on connects to your WordPress site and runs your custom functions.

Google Sheets Add-on →

# Common Tasks

# Import WordPress Data to Google Sheets

  1. Create an "Import to Sheet" function in WordPress
  2. In Google Sheets, use the SheetPoet add-on to run the function
  3. WordPress data appears in your spreadsheet

# Update WordPress from Google Sheets

  1. Create an "Upload to Website" function in WordPress
  2. Prepare your data in Google Sheets
  3. Use the SheetPoet add-on to send the data to WordPress
  4. Data is updated in WordPress site by your function

# Run Custom WordPress Functions single time

  1. Create a "One-time Trigger" function in WordPress
  2. Use the SheetPoet add-on to trigger the function
  3. View the results in Google Sheets

# Documentation

# System Requirements

  • WordPress 6.0+
  • PHP 7.4+
  • Google Chrome, Firefox, Safari, or Edge browser

# Support

Need help? Contact our support team at [email protected].