Sheets to Reddit#

Easily post Google Sheets on Reddit

Google Workspace Marketplace

apps-script icon google-sheets icon javascript icon

Sheets to Reddit

Description

Use this add-on to post your Google Sheets data straight to /r/googlesheets and other subreddits. You can also copy the markdown table for use anywhere else. Formatting can be retained. The add-on includes a custom function for generating tables within cells. ​ This add-on has no affiliation with Reddit. REDDIT is a registered trademark of reddit inc.

How To Use

To get started, highlight the range you want to post on Reddit. Go to ‘Add-ons > Sheets to Reddit > Active Range​’ and you will be prompted with options for formatting, A1 notation and showing formulas. These settings are saved per user. You can also click on ‘Add-ons > Sheets to Reddit > Specify Range​’ to type a range in manually. IMAGE

After this you will be presented with a dialog where you can select which subreddit you wish to post to and whether to share just your data, or a link to your document as well. Both options will open a new tab with a pre-filled post for you to edit. The post will contain your data and some prompts to get you started. You’re encouraged to edit this post and include as much detail as possible. The first button will also change the sharing permissions of your document to ‘anyone with the link can view’ and add a link to the document in your post. Learn more about document sharing on Google’s support page. IMAGE

=S2R() Function

Entering =S2R() allows you to generate Reddit compatible tables in a cell. It takes the following parameters:

Permissions

Here’s what Sheets to Reddit does with each of the permissions it requires:

Uh-oh, Something Broke!

Contact me, giving as much detail as you can.

Changelog