Alex marshall


Business development @ coherent
continuously working on side projects
Very rarely finish them

About

I graduated from University of Bath in 2015 with a degree in International Management & German. 💼🇩🇪

I spent a year working as Head of Marketing at a social media network before joining Coherent as a Business Development Manager. We make software for managing coworking spaces 👩‍💻👨‍💻

I've made a bunch of products as side projects, most of which were made with no-code. Most of them made $0 revenue. And most of them are now no longer updated, or dead 💀

When I'm not making stuff, I'm probably playing video games 🎮

I love languages, psychology, cars, travel and creating stuff ❤️

WORK

I work for a startup called Coherent - a SaaS product for managing shared workspaces. My role is Business Development Manager which loosely equates to product development + project management + marketing + sales + customer support + QA - and I love it!

Coherent handles everything from bookings and resource management, to invoicing and payment collection. Our team has 10+ years experience running coworking spaces, so we know all about the admin issues faced by them

If you want to know more, send me an email

Projects

Here's some of the things I've made. To see what I'm currently working on, find me on wip.chat

Achievement Calendar
🍼 Jan 2018

⏰Reminders for date specific Xbox achievements

🤖Made using code for Chrome extension - HTML, CSS, Javascript. Google Calendar + IFTTT for Telegram bot

Xbox Game List
🍼 Oct 2017
💀 Dec 2017 (still live, needs updating)

📋List of all Backwards Compatible, EA Access and Game Pass Xbox Games
🛠️ Built mainly for my own need
🤖Made using no code - airtable + carrd
🔜Make into bot using airtable/google sheets as database

Bwthyn Guddfan
🍼 Oct 2017

🏠Monthly blog from my dad about life with a wooden Garden Lodge in his garden
🤖Made using no code - carrd

21 Websites
🍼 Oct 2017
💀 Oct 2017 (no traffic)

💸Pay $2 to post your website. Maximum 21 displayed at any one time. Old ones pushed off by new submissions
🛠️ Built to see if this model could work
😎$8 total revenue
🤖Made using no code - carrd + Stripe
💀Didn't drive enough traffic to website, so ROI was bad for customers

Sharpen
🍼 Apr 2017

➕Simple maths problems every time you open a new tab
🛠️ Thought it would keep your brain sharp because it would be doing really easy work with every new tab
🤖Made using code - HTML, CSS, Javascript

The Edgy Tab
🍼 Apr 2017

📣Chrome extension showing quotes from Dan Waldschmidt with each new tab
🛠️ First freelance job. Hired on the back of a Chrome extension I posted to Product Hunt
🤖Made using code - HTML, CSS, Javascript

Gary Vee Motivation
🍼 Mar 2017

📣Chrome extension showing quotes from Gary Vaynerchuk on every new tab
🛠️ Wanted to learn to code, Chrome extension seemed like good place to start
🤖Made using code - HTML, CSS, Javascript

Forza Reminders
🍼 Feb 2017

⏰Reminders for Forzathon events in Forza Horizon 3 & Motorsport 7
🛠️ Built 100% to solve my own problem
👨‍👩‍👧‍👦~4k users across Messenger, Facebook, Twitter & Telegram
🤖Made using no code - Chatfuel, buffer, IFTTT

Startup Wisdom
🍼 Nov 2016

🧠 Curated startup advice sent daily via Messenger
🛠️ Wanted to learn about bots and Chatfuel
👨‍👩‍👧‍👦~7k total users across Messenger, Facebook, Twitter & Instagram
🤖Made using no code - Chatfuel, buffer
💰Currently for sale, dm me if interested

Tutorials

These are some of the tutorials I've searched for but couldn't find, so I wrote them myself

How to build a bot to select random messages from a series and send them to Telegram

How to create 'Share to twitter' links

How to build a Telegram "bot" with no code

How to build a crowdsourced stash with no code

How to build a Telegram "bot" with no code

What you’ll need:

A Telegram account
An IFTTT (If this then that) account
A google calendar

Step 1 — Go to ifttt.com and create a free account

Step 2 — Open Telegram and search for IFTTT. Open a conversation with it and follow the instructions to connect IFTTT to your Telegram account

Step 3 — Create a public Telegram channel

Step 4 — Add IFTTT as an admin to your channel (as of writing this, this wouldn’t work in the iOS app or on Web Telegram — I had to use the Mac app). You can either go to ‘Channel info > invite admins’ or go to the Info page for IFTTT > Add to Group.

Step 5— Copy your channel share link i.e. https://t.me/achievementcalendar, type /connect_channel into the conversation with IFTTT. Wait for the response then paste your channel share link

Step 6 — Go back to ifttt.com and create a new applet. Choose Google Calendar, then ‘Event from search starts’. Choose the calendar you want IFTTT to look in, and choose a keyword. Next choose Telegram and ‘Send message’ — you should see your newly created Telegram channel. Customise the message text making use of the available ingredients

Step 7 — Create an event in Google Calendar. Make sure to include your keyword in the event name, and make sure you’re adding the event to the correct calendar. *Note that you’ll need to add <br> at the end of the event description if you want line breaks to appear in Telegram.

Step 8 — Once you’ve created your event, wait until it starts and your message should arrive in Telegram. On the first try, I’ve always had to force IFTTT to ‘check now’ in order for the message to arrive. Afterwards the message arrives within 1–2 minutes after the event start time.

And that’s it! It’s a pretty basic bot, but if you want to send scheduled messages to a bunch of people, it’s a quick way of making one.

How to build a crowdsourced stash with no code

A stash is a website that shows a collection of stuff. Everyone is making stashes at the moment - stashes of tools for startups, or tools to build bots, basically anything you can think of

Stashes can take a while to create because you have to find and input all the content yourself

Here's how you can crowdsource that work and build a stash with no code

All you'll need to use is Bubble - it's basically a drag and drop, no-code website builder. But what makes it a bit more unique and a lot more powerful is the fact it gives you access to a database

To get started, draw a couple of 'Input fields' and a 'button'. In this example I'm crowdsourcing links to video game soundtracks, so I've got a field for the name of the game, and a field for the link.

Next you need to create a 'Workflow'. This is basically a series of triggers and responses that do something. In this case, submitting the data from your input fields into your database. To start, click 'Workflow' on the left - here's the steps you'll need to get it set up

1. Click 'Create new event'
2. Choose 'Elements' and 'a new element is clicked'
3. In 'Element' select the button you created next to your input fields. You can leave the rest as it is
4. Next 'add an action', choose 'Data' and 'Create a new thing'
5. Create a new 'Type' based on the data you're collecting - mine is just called 'Soundtrack'
6. 'Set another field', 'create new field' - this is related to a specific input field. For example, I have a field called 'game title' related to the game name field, and one called 'spotify URL' relating to the Spotify field. You can create as many fields as you want, even if the user isn't submitting any info for it. In my example, I create a field in the database for 'album art' even though the user doesn't submit album art. This means that I can upload album art myself into each database entry
7. Once you've created a field, you should see 'insert dynamic data' on the right - click that and you'll see an option for the input fields you created. Repeat this for each input field you've created on your website
8. Optionally, you might want to add something into the workflow to empty the input fields once the user clicks submit - if so, add a new action, choose element actions and reset inputs

That's the whole workflow created - you can tweak it and edit it whenever you need

Next you need to display the content that's being submitted

Go back to 'Design' in the left menu and draw a 'Repeating Group' - you can find this under 'Containers'

In 'Type of Content' you'll want to use the 'Type' you created in your workflow earlier - in my case 'Soundtrack'

In 'Data source' choose 'Do a search for' and choose your Type again

Optionally you can sort the data that's displayed in the cells - I sort them in descending order based on creation date so that newer submissions appear at the top

Then in the top left cell of your repeating group, design it in the way you want the content to be displayed on your website

If you add text or images, you can pull in the information from the database. In 'edit me...' choose insert dynamic data - the top option should be 'Current cell's [your type name]' for example 'Current cell's Soundtrack' in my case. Choose this

Afterwards you can then choose which piece of data you'd like to pull in

And that's it! There's plenty you can change and customise based on what you want to do, but that's all you need to do in order to create a crowdsourced stash.

Click preview in the top right corner and you'll be able to test it. If you submit something and it appears immediately in your repeating group - success!

You can check out Soundtrack Stash here

How to build a bot to send a randomly selected message to Telegram every hour

This tutorial is handy if you've got a series of messages like famous quotes, scientific formulas, definitions or German translations and you want to send them at random to Telegram on a regular basis.

All you'll need for this is a Telegram Channel or Group, a Twitter account, a twitter bot made using cheapbotsdonequick.com and IFTTT

The Twitter bot will choose a message and random and tweet it from your chosen account. Using IFTTT the contents of this tweet will then be sent to Telegram

The first step is to create your Telegram Group or Channel. After that you need to set up your Twitter account

Next you want to go to cheapbotsdonequick.com, log in and authorise access. You'll then see a description of how the service works and a big text box titled 'Tracery JSON'. This text box is where you will paste your series of messages.

The placeholder text shows how you can create strings of words allowing the bot to pick and choose words from different strings to form it's own tweets. This is useful if you want randomly generated phrases. If you don't, you can remove all the text in between the { } apart from "origin": [ ]. Here's how it should look

Now you need to prepare the messages you want to send. You can do this in TextEdit or WordPad or you could use something like Sublime Text.

There are a couple of formatting things you need to be aware of. Each message must be wrapped in " " and at the end of each message (after the ") you need to add a comma (,). The very last message in your series should not have a comma. It's worth double checking that your message will fit within a 280 character tweet too

If you see any errors below the text box after you've pasted in your messages, chances are you've missed a " or , so double check them first

Below the tickbox is a field that shows an example tweet that it can send. You can hit the refresh button next to it to make sure everything looks correct.

Next choose the frequency you want the messages to be sent and whether you want your twitter bot to reply to mentions.

*One thing worth mentioning here - twitter doesn't let you post two similar tweets within a short period of each other and the same principle applies for these bots. So if you notice that your bot isn't posting any more, and all your messages are quite similar (not necessarily identical), then that's probably the reason.

Once you're happy that your twitter bot is working, you can now set up your IFTTT recipe.

Head on over to ifttt.com and create a new Applet. Click 'This' and choose Twitter, then 'New tweet by a specific user' and enter the handle of the twitter account you created.

Click 'That', then search for Telegram, then 'send message'. Choose your Telegram Group or Channel and then customise the message text using the Ingredients. If you just want to send the contents of the tweet, delete all the text and just choose 'Text' from the Ingredients list. Save the Applet and you're done!

To check that everything's working, you can either wait until your bot posts a tweet, or you can go back to cheapbotsdonequick and force your bot to tweet, or you can just manually post a tweet yourself from the account.

Applets can sometimes take a while the first time they're used, so in IFTTT you can force it to 'check now'. After that, everything should be automatic.

And that's it - you now have a bot that can pick a random message selected from a series and send it to Telegram - all with no code!