Hi There would be 3 ways to do that: 1) If this is the same attachment all the time - use Google Drive Download File module and you will be able to attach this your email in Gmail 2) If you have e.g. 3 different templates with different attachment, you could attempt to do above but have router and 3 legs with filters based on e.g matching the subject leading to download a file and send email modules afterwards. Might grow messy quickly. 3) have a field inside your Sheet with either attachment name (if it is unique) or attachment link and use that to find Document ID and use that in Download File module.
This video is such a life saver! You're giving me back so much of my time. Question: I've created an newsletter template within Workspace Gmail that I send to new sign-ups. Is it possible to send that template instead of plain text from the Sheets cell?
Glad to hear that. I see 2 options: 1) You copy the HTML of that newsletter template into Gmail module in Make/Integromat (send it to yourself and open emails source if you cannot see HTML otherwise) 2) There is a "Copy email" module in Make/Integromat - so you coudl - create a draft with template - use "Copy email" to make copy of the draft and use its ID in the next "Send email" module addressed to the person from the Google Sheet list. Let me know if that helps?
I appreciate your previous reply very useful video! Though I am wondering, is there a way to slow down how fast the emails are sent out? im afraid to get flagged as spam or a bot. Thank you!
2 options, 1) I think it is possible to limit how many rows Make/Integromat reads from Google Sheets. e.g 10 rows at a time and run scenario every 37 min so that you can vary the time 2) there is a "Sleep" module in Make/Integromat which you can set for example for 1 min between each email.
Great video, thank you! However, I'm having an issue with the scheduling process. Although the journey runs without any issues, I'm having trouble with the scheduling not executing after the set 15-minute time frame. Do you have any idea why this may be happening?
Can you explain a bit more? You have created the scenario, set schedule for every 15 min, turned it on, right? The scenario does not run? Or does run but doesn't send anything? Are there emails in status ready to be sent?
Thanks for this! I want to be able to automate sending follow-up emails only if a contact hasn’t replied to the first email I sent. How do I make rhis possible?
In this case you could manually mark, who has replied in the same google sheet and use Google Sheet search rows for rows only where there is no mark. To those people you send email from a second scenario.
Yes totally! This can be executed in 3 ways: 1) Formula result in Sheets (whatever formula you can imagine) says for example YES -> Make/Integromat Google Sheet module searches only for YES 2) Make/Integromat Google Sheet module searches for multiple conditions in multiple fields 3) Use filter or router and filters between Google Sheets and Gmail to filter out emails if conditions are met. Bonus - with router and filter you can also have multiple actions here - multiple Gmail modules.
What if I need to put a variable such as an adress for a property in the middle of a body paragraph. (ie. I saw your apartment at "123 Sesame" st) If I make 123 sesame street as a variable in google sheets.
In such case you could use =CONCATENATE("text","variable","text after variable") - probably instead of using pure text it would make sense to link to fields that would contain it. Or you can just have 3 text columns in Sheets and glue them inside of Integromat. Let me know if this helps?
what if i want to send emails to different users on a different day periodically? Eg, every 10 days send A,B,C an email and every 5 days send D,E,F an email?
In this case instead Watch Rows module you could use Search Row with 2 extra columns -> a)date when email should be send next + b) column: how many days until next send (10 or 5) Then you add following filter on Make/Integormat if date in a) is less then today -> send email and update row adding number in b) to date a) -> this will push next send for by a given number of days.
Great tutorial, thanks! This will really help with my overseas RFQs. I'm having a couple of issues though, The first is the format of the body. I'm sending a mail with spacing between texts, as well as bullet points (written manually in my Sheets), but when I run it, I receive the email as a flat text, using space instead of enter between paragraphs. Where and how can I edit this to better match my manual format? The second issue is my signature, and it's pretty much the same as the last point, adding only that in my signature I use more formatting (colors, underlining, bold, etc...) and pictures (arranged specifically to match some text titles). Is it possible to edit this to make it look like my manual format?
Yes, you would basically need to convert it all to HTML - here is basic online editor that helps with it html-online.com/editor/ you can copy paste your existing signature and copy the HTML for the Gmail module. You can also send yourself an email in Gmail and open that email with "inspector" in chrome and copy HTML from there.
Is it possible to send mails to multiple addresses? I've tried putting 2 mails in a single cell (separated by a ";") and having different columns. On the first case it marks error, and on the second it ignores the second mail and sends only the first address. Do you have any tips for this situation?
It is possible to use with any email provider. Instead of Gmail, you might use the Mail365 module (assuming your office email is on Microsoft 365). If that is not the case there is also the fully customizable SMTP module - which will work with any email, you just need to know details of your email server.
Hi! Great tutorial, thanks! The first time I run, all goes well. When I schedule it it doesn't run and if I only run the watch rows module it comes back with 0 lines. Can you help me with this? Thanks
You could add a column "emai 1 send date" and "email 2 send date". Next thing you set up scenario to search records that have only one send date and if send date 1 is more than e.g. 14 days from today scenario would send another email and fill out " send date 2".
Yes totally. To add you need to edit the Gmail module and add it at the bottom of the "body" under the text of your message. It needs to be HTML format but if you don't want to write HTML by hand this website has some pretty neat feature - copy paste formatted text - get HTML html-online.com/editor/
Try: 1) type some regular text in the email content in Gmail module - see if this works 2) second stage - select some other variable from Google Sheet (like email) to put into content - see if this works 3) double check the if the text from Google Sheet is visible in Integromat (check the details of data in the bubble on Google Sheet Module).
i want to send the mails to the same people but the scenario only considers the newly added rows and ignores the precedant ones. I can't create new rows with the same people everytime. Is there a way to make it read the "not empty rows" instead of the new rows. Thanks in advance
Yes You can use "Search rows" module and filter out only rows that are empty (eg. in column D) and send email to those. Afterwards you can add "Emails sent" text to the column you are using as sending criteria.
Yes, you can connect office 365 accounts (there is a module for that in integromat) or you can connect other standard STMP emails server (if your emails is not Gmail or 365 - likely it can be connected via STMP).
Sometimes Integromat catches a bug with the scheduling, when there was first set scheduling and than there is an instant module at the start. I would temporarily change the start module to anything else that runs on schedule and set time. Save. Change back to Google Sheets.
You could add sleep module to pause for example for 1-60 minutes or you could limit number of records return from Airtable "Max records" so it only sends e.g. batches of 5 at a time.
You would have to check latest details in Google T&C but it used to be 500 emails per day per Gmail and 2000 emails per Google Workspace account (the business Gmail). If you need more than that -> definitely switch to SendGrid instead the Gmail module. Checkout I have another video about it. czcams.com/video/rxqgH2bFDTs/video.html
Hi the HTML is super basic all you need to know: This is paragraph. This is another paragraph. This means there will be a gap (think "Enter") between sentences that you put in paragraphs With kind regards Greg
According to Milton Friedman, technically it cannot be. However if we allow ourselves to ignore any more theoretical opportunity costs (related to the fact you are building this yourself, instead of getting marketing software) as well as the fact that most services lure you with free tiers as a opportunity to sell you priced services with higher level of usage (which I consider fair game), the answer would be yes.
😉 so in summary: Google free ( but there is daily limit how many emails you can send -> I think max 2000) Integromat free 1200 operations/month - so with 2 operation to send email this gives you 600 emails per month more less
@@popovicsgyorgy add the email as new row or change settings in the start module, when should it start. Right click on the module and select starting date/bundle.
This can work as well, you would have to start with Gmail module and send back replies to Google Sheets. Checkout this video it shows similar start and could be repurposed czcams.com/video/ei_xBP0LHJg/video.html
It might be issue with the link you are using. Try for a test attaching a different link (e.g. www.google.com/q=test) and see if it works with a different link. If so this means the issue is with your link. If your link (or its domain ) is a problem you may try using email shortener like bit.ly and see if that works.
Hi! This is great and very useful! You saved my life! Wondering if we can add an attachment as well? Thank you!!!
Hi There would be 3 ways to do that:
1) If this is the same attachment all the time - use Google Drive Download File module and you will be able to attach this your email in Gmail
2) If you have e.g. 3 different templates with different attachment, you could attempt to do above but have router and 3 legs with filters based on e.g matching the subject leading to download a file and send email modules afterwards. Might grow messy quickly.
3) have a field inside your Sheet with either attachment name (if it is unique) or attachment link and use that to find Document ID and use that in Download File module.
Thank you for your reply! I used these and they worked perfectlythank you
Man, I'm So Happy that I've found your channel, very straightforward, great explanation.
Thank you so much 👍🙏
Happy to hear that!
Thank you!!! It is the very simple way I have seen. I have seen a lot of videos for the same need, but yours is clear and simple!
Glad it helped!
This video is such a life saver! You're giving me back so much of my time.
Question: I've created an newsletter template within Workspace Gmail that I send to new sign-ups. Is it possible to send that template instead of plain text from the Sheets cell?
Glad to hear that. I see 2 options:
1) You copy the HTML of that newsletter template into Gmail module in Make/Integromat (send it to yourself and open emails source if you cannot see HTML otherwise)
2) There is a "Copy email" module in Make/Integromat - so you coudl - create a draft with template - use "Copy email" to make copy of the draft and use its ID in the next "Send email" module addressed to the person from the Google Sheet list.
Let me know if that helps?
@@BusinessAutomatedTutorials This absolutely helps!
Thank you!!!! Saving lives here, txs a lot!
You are so welcome!
I appreciate your previous reply very useful video! Though I am wondering, is there a way to slow down how fast the emails are sent out? im afraid to get flagged as spam or a bot. Thank you!
2 options,
1) I think it is possible to limit how many rows Make/Integromat reads from Google Sheets. e.g 10 rows at a time and run scenario every 37 min so that you can vary the time
2) there is a "Sleep" module in Make/Integromat which you can set for example for 1 min between each email.
thank you for shared us good content voice and teaching way is very clear.
Glad it was helpful!
Great video, thank you! However, I'm having an issue with the scheduling process. Although the journey runs without any issues, I'm having trouble with the scheduling not executing after the set 15-minute time frame. Do you have any idea why this may be happening?
Can you explain a bit more? You have created the scenario, set schedule for every 15 min, turned it on, right?
The scenario does not run? Or does run but doesn't send anything? Are there emails in status ready to be sent?
Thank you!
Glad it is helpful
Thanks for this! I want to be able to automate sending follow-up emails only if a contact hasn’t replied to the first email I sent. How do I make rhis possible?
In this case you could manually mark, who has replied in the same google sheet and use Google Sheet search rows for rows only where there is no mark. To those people you send email from a second scenario.
@@BusinessAutomatedTutorials Thank you for the help! Really appreciate it
Nice one! Can this be used with if statements to send an email only if a particular condition is met?
Yes totally! This can be executed in 3 ways:
1) Formula result in Sheets (whatever formula you can imagine) says for example YES -> Make/Integromat Google Sheet module searches only for YES
2) Make/Integromat Google Sheet module searches for multiple conditions in multiple fields
3) Use filter or router and filters between Google Sheets and Gmail to filter out emails if conditions are met. Bonus - with router and filter you can also have multiple actions here - multiple Gmail modules.
@@BusinessAutomatedTutorials Thanks! Very helpful
What if I need to put a variable such as an adress for a property in the middle of a body paragraph. (ie. I saw your apartment at "123 Sesame" st) If I make 123 sesame street as a variable in google sheets.
In such case you could use =CONCATENATE("text","variable","text after variable") - probably instead of using pure text it would make sense to link to fields that would contain it.
Or you can just have 3 text columns in Sheets and glue them inside of Integromat.
Let me know if this helps?
This was super helpful, thank you!
You're so welcome!
what if i want to send emails to different users on a different day periodically? Eg, every 10 days send A,B,C an email and every 5 days send D,E,F an email?
In this case instead Watch Rows module you could use Search Row with 2 extra columns -> a)date when email should be send next + b) column: how many days until next send (10 or 5)
Then you add following filter on Make/Integormat if date in a) is less then today -> send email and update row adding number in b) to date a) -> this will push next send for by a given number of days.
Great tutorial, thanks! This will really help with my overseas RFQs. I'm having a couple of issues though,
The first is the format of the body. I'm sending a mail with spacing between texts, as well as bullet points (written manually in my Sheets), but when I run it, I receive the email as a flat text, using space instead of enter between paragraphs. Where and how can I edit this to better match my manual format?
The second issue is my signature, and it's pretty much the same as the last point, adding only that in my signature I use more formatting (colors, underlining, bold, etc...) and pictures (arranged specifically to match some text titles). Is it possible to edit this to make it look like my manual format?
Yes, you would basically need to convert it all to HTML - here is basic online editor that helps with it html-online.com/editor/ you can copy paste your existing signature and copy the HTML for the Gmail module.
You can also send yourself an email in Gmail and open that email with "inspector" in chrome and copy HTML from there.
@@BusinessAutomatedTutorials Many thanks! I'll try both options, I didn't realize HTML could be this easy
Is it possible to send mails to multiple addresses?
I've tried putting 2 mails in a single cell (separated by a ";") and having different columns. On the first case it marks error, and on the second it ignores the second mail and sends only the first address.
Do you have any tips for this situation?
@@lic.enriquesanchezgonzalez9649 change field formatting to "map" (turn on the swith) and coma separate the emails ","
Really easy to follow… Thank you
Glad you liked!
Is it possible to do with a work email not through gmail? Such as using mail on windows 10?
It is possible to use with any email provider. Instead of Gmail, you might use the Mail365 module (assuming your office email is on Microsoft 365). If that is not the case there is also the fully customizable SMTP module - which will work with any email, you just need to know details of your email server.
Question: Would it be possible to send 2 separate emails for the same row reference, say a confirmation email to user and an email to vendor?
Yes absolutely, copy the Make Gmail module - now you are sending 2 emails!
Thanks a lot! Was really helpful and works perfectly!
Great to hear!
Hi!
Great tutorial, thanks!
The first time I run, all goes well. When I schedule it it doesn't run and if I only run the watch rows module it comes back with 0 lines.
Can you help me with this?
Thanks
Does it work when you add new rows and run the scenario afterwards manually?
Thank you so much!
Welcome! Glad it is useful!
Can you tell how to send email again after first email send date
You could add a column "emai 1 send date" and "email 2 send date". Next thing you set up scenario to search records that have only one send date and if send date 1 is more than e.g. 14 days from today scenario would send another email and fill out " send date 2".
Thank you so much! Is there a way to include a custom signature that has an image?
Yes totally. To add you need to edit the Gmail module and add it at the bottom of the "body" under the text of your message. It needs to be HTML format but if you don't want to write HTML by hand this website has some pretty neat feature - copy paste formatted text - get HTML html-online.com/editor/
Thanks for the tutorial! But the body of the text is not being sent in my email. Any idea why this would happen?
Try:
1) type some regular text in the email content in Gmail module - see if this works
2) second stage - select some other variable from Google Sheet (like email) to put into content - see if this works
3) double check the if the text from Google Sheet is visible in Integromat (check the details of data in the bubble on Google Sheet Module).
Let me know if that helped?
i want to send the mails to the same people but the scenario only considers the newly added rows and ignores the precedant ones. I can't create new rows with the same people everytime. Is there a way to make it read the "not empty rows" instead of the new rows. Thanks in advance
Yes You can use "Search rows" module and filter out only rows that are empty (eg. in column D) and send email to those. Afterwards you can add "Emails sent" text to the column you are using as sending criteria.
Can I send this from another email rather than from Gmail?
Yes, you can connect office 365 accounts (there is a module for that in integromat) or you can connect other standard STMP emails server (if your emails is not Gmail or 365 - likely it can be connected via STMP).
I followed the exact same steps but when I try to run it, it says "Invalid scheduling". Why is this happening?
Sometimes Integromat catches a bug with the scheduling, when there was first set scheduling and than there is an instant module at the start. I would temporarily change the start module to anything else that runs on schedule and set time. Save. Change back to Google Sheets.
How to know who send the data in googlesheet?can you help me sir?
The information who edited the row or who added new row is unfortunately not provided in Google Sheets data going to integromat.
TYSM
My plesure bro, I hope it is helpful.
Can you throttle or add wait codes so all the emails dont go out at once?
You could add sleep module to pause for example for 1-60 minutes or you could limit number of records return from Airtable "Max records" so it only sends e.g. batches of 5 at a time.
i can send from the gmail part! :( urgent help pls
are you using free Gmail or Google Workspace gmail?
How many mails can we send with it?
You would have to check latest details in Google T&C but it used to be 500 emails per day per Gmail and 2000 emails per Google Workspace account (the business Gmail).
If you need more than that -> definitely switch to SendGrid instead the Gmail module. Checkout I have another video about it. czcams.com/video/rxqgH2bFDTs/video.html
I need the HTML code part I cant see what you used and don't know anything about HTML really
Hi the HTML is super basic all you need to know:
This is paragraph.
This is another paragraph. This means there will be a gap (think "Enter") between sentences that you put in paragraphs
With kind regards
Greg
Is this totally free?
According to Milton Friedman, technically it cannot be. However if we allow ourselves to ignore any more theoretical opportunity costs (related to the fact you are building this yourself, instead of getting marketing software) as well as the fact that most services lure you with free tiers as a opportunity to sell you priced services with higher level of usage (which I consider fair game), the answer would be yes.
😉 so in summary:
Google free ( but there is daily limit how many emails you can send -> I think max 2000)
Integromat free 1200 operations/month - so with 2 operation to send email this gives you 600 emails per month more less
Hi! How can i resend the emails?
Resend? You mean send exactly the same email again? Send 2 times immediately or after a while?
@@BusinessAutomatedTutorials The same. When I push it again to send it
@@popovicsgyorgy add the email as new row or change settings in the start module, when should it start. Right click on the module and select starting date/bundle.
@@BusinessAutomatedTutorials thank you!
What about received replies ???
This can work as well, you would have to start with Gmail module and send back replies to Google Sheets. Checkout this video it shows similar start and could be repurposed czcams.com/video/ei_xBP0LHJg/video.html
Hi sir, if add My link My massege Go to spam, what i can doing
You mean add link inside of the message?
If you send emails without any links included does it work?
@@BusinessAutomatedTutorials Yes sir
@@BusinessAutomatedTutorials Yes but the problems if is not add My link , i and not promotes My offer
It might be issue with the link you are using. Try for a test attaching a different link (e.g. www.google.com/q=test) and see if it works with a different link. If so this means the issue is with your link. If your link (or its domain ) is a problem you may try using email shortener like bit.ly and see if that works.
thanks!!
You're welcome!