Hey guys,
I’ve been trying to create a scenario that sends out an email when a new row is added to a Google sheet. I keep getting this error when running the scenario. Is anyone able to help me?
1 Like
HI @Shalom_Banda and welcome!
There seems to be a problem with the data Google Sheets receives.
The only way to know what’s happening is for you to provide the input and output bundles, and ideally, a picture of your flow when you run it so we can see where the problem is.
L
Please ensure you have properly mapped the sheet name along with mappings in cell values.
This should solve the problem. If not, please share the screenshot of your mappings.
Regards,
Msquare Automation - Gold Partner of Make
Explore our YouTube Channel for valuable insights and updates!
1 Like
Welcome to the Make community!
If you need further assistance, please provide the following:
1. Screenshots of module fields and filters
Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.
You can upload images here using the Upload icon in the text editor:
2. Scenario blueprint
Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
(Note: Exporting your scenario will not include private information or keys to your connections)
Uploading it here will look like this:
blueprint.json (12.3 KB)
3. And most importantly, Input/Output bundles
Please provide the input and output bundles of the trigger/iterator/aggregator modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
A.
Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
Uploading them here will look like this:
module-1-output-bundle.txt (12.3 KB)
B.
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:
-
Either add three backticks
```before and after the code, like this:```
input/output bundle content goes here
``` -
Or use the format code button in the editor:
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
Following these steps will allow others to assist you here. Thanks!
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
1 Like
Hey @L_Duperval thank you for your response. Here are the screenshots I took:
I’m not very technical so if you need any specific screenshots kindly guide me or send a screenshot too of what you need to see.
Hey @Msquare_Automation thank you for your reply. Here are the screenshots I took. Please let me know by example if you need more specific screenshots.
Additionally, here is the exported blueprint:
blueprint.json (18.8 KB)
Additionally here’s the blueprint:
blueprint.json (18.8 KB)
@L_Duperval @Msquare_Automation @samliew Thank you for your help, after reading your instructions and having a careful analysis, I found the issue which was a simple misspelling in the sheet row range. It’s working now, thanks again!
4 Likes
Glad to know that your issue is resolved.
Regards,
Msquare Automation - Gold Partner of Make
Explore our YouTube Channel for valuable insights and updates!