New post - QUERY pro tip

Hi all,

Are you using the QUERY() formula ? Have you ever wondered if you could use it by selecting the column names and not the letters?

I leave you this article that explains step by step how to do it.
https://medium.com/@magic.sheets/how-to-create-queries-based-on-column-name-google-sheets-1d4fa7e8d487

Have a nice week!
Like Comment

NEW PRODUCT - Project management

Hi all!

I just uploaded a new product to manage projects and tasks from Google sheets.

I personally used it for some projects and found it super simple and very useful.

I hope you find it as useful as I do: https://magicsheets.gumroad.com/l/project_management_googlesheets 

NEW PRODUCT!

Hi all,

I want to share with you my new template: https://magicsheets.gumroad.com/l/whatsapp_googlesheets

It's a tool to send WhatsApp messages from Google sheets!
Like Comment

2 articles on medium

Like Comment

Gumroad admin - Google sheets. NEW PRODUCT!

Hi everyone!

I invite you to check out my new product, uploaded yesterday: https://magicsheets.gumroad.com/l/gumroad_googlesheets

It connects via API to Gumroad from Google sheets.

Some interesting features:

- You can create discount codes and assign them to a product (with the length of characters you want). I used it to upload 5400 codes to a product in 2 minutes!
- Delete discount codes
- Pull your sales into sheets
- Pull your products info into sheets

Great opportunity to automate some processes like store owners in Gumroad.
Like Comment

Discount codes

There is a way to add more than 1000 discount codes to one product in a simple way?
Like Comment

Affilates program

I launched 4 products yesterday and am looking for affiliates to sell them!

Good commissions and great products.

Interested comment and I'll add you!
Like Comment

New products!

Hello everyone!

I'm Milton, a Google sheets developer with many years of experience as a freelancer, doing all kinds of automations/integrations.

I decided to try to sell my time and start selling my knowledge as products.

Yesterday I launched my first 4 templates! You can see them here: https://magicsheets.gumroad.com/

They are google sheets templates with coding, API integrations with Slack, Shopify and more.

Thank you!
Like Comment