# Frequently Asked Questions

# General Questions

# What is SheetPoet?

SheetPoet is a tool that connects Google Sheets directly to your WordPress site, allowing you to execute WordPress functions and manage content directly from your spreadsheets.

# Do I need coding knowledge to use SheetPoet?

Basic knowledge of WordPress and Google Sheets is helpful, and some coding knowledge is required for creating custom functions. You can use AI tools to help you write the functions.

# Is SheetPoet free to use?

SheetPoet offers both free and premium versions. The free version includes basic functionality, while the premium version offers advanced features like function writer and priority support.

# What types of functions can I create?

You can create three types of functions:

Import to Sheet: Fetch data from WordPress and populate your spreadsheet (runs recursively until cancelled or empty return)
Upload to Website: Send spreadsheet rows to WordPress for processing (supports dynamic column values like , )
One-time Trigger: Perform one-time logic like syncing or cleanup (runs once and inserts data into selected sheet)

# How do the different function types behave?

Import to Sheet: Runs continuously in batches until you stop it or the function returns empty data. Perfect for importing large datasets.
Upload to Website: Processes spreadsheet data row by row, allowing you to map columns dynamically using , syntax.
One-time Trigger: Executes once and returns results to your sheet. Ideal for maintenance tasks or data analysis.

# How do I use dynamic column values?

For Upload to Website functions, you can map spreadsheet columns to function parameters using the `` syntax:

Set magic parameter title with value `` to pass Column A as the title
Set magic parameter content with value `` to pass Column B as the content
Set magic parameter status with value `` to pass Column C as the status

Your function can then access these as $record['title'], $record['content'], and $record['status'].

# Which WordPress versions are supported?

SheetPoet is compatible with WordPress 6.0 and above. We recommend using the latest version of WordPress for the best experience.

# Is it safe to run PHP from Google Sheets?

Yes. Each function is validated and sanitized, and only accessible via authenticated API calls. All API calls require a valid API key, generated in the plugin settings. Also, you can disable the entire functionality in the plugin settings when it's not being used.

# Does SheetPoet work with WordPress.com sites?

SheetPoet works with self-hosted WordPress sites and WordPress.com Business plans that allow plugin installation. It does not work with free WordPress.com sites.

# Installation & Setup

# Why can't I connect Google Sheets to my WordPress site?

Common connection issues include:

Incorrect API key
WordPress site not accessible from the internet
Plugin not activated on WordPress
Firewall or security plugin blocking the connection

# Can I use SheetPoet with multiple WordPress sites?

Yes, you can connect different sheets to different WordPress sites. Each connection requires its own API key.

# Features & Functionality

Any data can be processed by SheetPoet

SheetPoet has many potential use cases because it can process any data. This includes structured data like posts, users, and custom data, as well as unstructured data like text, images, and even JSON.

You need to define your own PHP functions to process the data in any way you want.

Sheetpoet sends and retirieves data in your defined function and the rest of the data processing is up to your function logic. So it is very flexible and powerful.

# Can I create custom post types with SheetPoet?

Yes, SheetPoet supports creating and updating custom post types. You need to specify the post type when using the create_post function.

# Does SheetPoet support custom fields?

Yes, you can create and update custom fields (post meta) using the appropriate functions in SheetPoet.

# Can I upload images from Google Sheets to WordPress?

Yes, you can specify image URLs in your spreadsheet, and SheetPoet can import them as media attachments in WordPress.

# Is it possible to delete content using SheetPoet?

Yes, SheetPoet includes functions to delete posts, users, and other content types. Use these functions with caution as deletions cannot be undone.

# Can I update existing content or only create new content?

SheetPoet allows both creating new content and updating existing content. For updates, you need to specify the ID of the item you want to update.

# Security

# Is it safe to connect my WordPress site to Google Sheets?

SheetPoet uses secure API keys and only allows authorized users to connect. All data is transmitted securely using HTTPS. Also, you can disable the entire functionality in the plugin settings when it's not being used.

# Who can access my WordPress site through SheetPoet?

Only users with access to the API key can connect to your WordPress site. You can revoke access at any time by regenerating the API key and deleting the old keys.

# Troubleshooting

# Why are my functions not executing?

Common reasons include:

Incorrect parameter mapping
Permission issues on WordPress
Timeout due to large data sets
Errors in the data format

# How can I see detailed error messages?

Go in the SheetPoet settings on your WordPress site, and check the history section in the sheetpoet plugin after executing a function.

# The plugin is activated but doesn't appear in Google Sheets

Plugin is for the wordpress site, the add-on is for google sheets. Make sure you've installed the Google Workspace Add-on in your google sheets.

# Where can I download the WordPress plugin?

You can download the latest SheetPoet WordPress plugin here: sheetpoet-v1.0.2.zip. See our installation guide for step-by-step instructions.

# Support & Updates

# How do I get support for SheetPoet?

For basic support, check our documentation and community forums. You can also visit the WordPress.org support forums. Premium users can access priority email support at [email protected].

# How can I help improve SheetPoet?

If you find SheetPoet helpful, please leave a 5-star review. Your support helps us improve!

# How often is SheetPoet updated?

We release updates regularly to add new features and ensure compatibility with the latest versions of WordPress and Google Sheets.

# Can I request new features?

Yes, we welcome feature requests. Premium users' requests are given priority in our development roadmap.

# Where can I find the Terms of Service and Privacy Policy?

You can find our Terms of Service and Privacy Policy on our documentation site.