Sheets to Reddit

Easily post Google Sheets on Reddit

- google sheets tagJavaScript tag Google Workspace Marketplace

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:

Further details can be found in the GSuite Add-on Privacy Policy.

Screenshots

Preview modal

The preview dialog allows the user to conveniently select where they want to post their data, as well as warning about sharing sensitive information.

Formatting modal

The formatting modal allows the user to select which text styles, cell references, and formulas to keep.

Post preview

The add-on automatically links to a pre-filled Reddit post on the users chosen community.

Changelog