How to Use the Make SubString Function with 5 Example Use Cases

Yes, you can set up an automation with Make to transfer data from your Gmail into Google Sheets. The workflow starts with the Gmail application, you’ll need to select Watch Emails and then connect your Google account. Define the specific folder you want to watch in Gmail and create a filter to ensure only relevant emails are processed. Once the emails are selected, use the Google Sheets application to define the spreadsheet and the specific cells where the fetched data should be deposited. Lastly, define a schedule for the automation and activate the scenario.

Yes, Make.com allows you to decide exactly when your Scenarios run.

Make.com is a “low-code” platform, meaning you can use it without coding skills, but knowing a bit about coding can help you do even more.

Yes, Make.com has a free plan that offers two active Scenarios and 1,000 operations per month.

To integrate monday.com and Google Sheets, you need to create a simple automation that will update both platforms simultaneously when there are changes made. Create a monday.com board and a Google Sheet with the same column names. Set up an automation where, whenever there is a new item added or updated to the monday.com board, it will also be added or updated in the Google Sheet. You can use search functions to determine whether an item already exists in the Google Sheet, and then either add a new row for a new item, or update an existing row for an updated item.

Using automation tools like Integromat with Google Sheets, you can specify different actions depending on whether a data entry already exists. In the case of a database search that yields results, meaning the entry already exists, you can automate the tool to update the existing row. However, if the search comes up empty, indicating the entry does not yet exist, the tool can be programmed to create a new row. This differentiation is often set up using filters which check for the existence or absence of a specific identifier (like a row number) to trigger different automated responses.

To set up a workflow using Google Sheets and Slack with Make, start by setting up the Google Sheets trigger, which will monitor for updates in your chosen spreadsheet. Following this, define the action, in this case, creating a Slack message. You’ll need to connect to your Slack account, specify the type of connection (user or bot), and define who should be the recipient of the message. The actual message can be a combination of static text and dynamic data pulled from the spreadsheet. You then need to set up a schedule for how often the workflow should run and activate the scenario.

You’ll get an email with a yellow triangle in the subject line, signaling that your scenario has encountered warnings. This email is all about keeping you in the loop on issues like connectivity failures.

After that first email, Make.com will send you another one in 5 minutes. This one will have a link to your scenario history where you can see what’s up.

Generally, Make.com is more budget-friendly than Zapier.