Automation gmail problem

Help Studio
1

Hi,

I have a problem since 2 days and I can’t resolve it…

I’d like to automate the connection to all my email addresses at 5.10pm, for example.

1 Start automation at 5:10pm
2. Find login1 and password1 in cell A1 and B1 of my google sheet
3 Open GMAIL/browser and type Login1 in login and password1 in password and click on connect.
4. Open a new tab
5. Find login2 and password2 in cell A2 and B2 of my google sheet.
6 Open GMAIL…
7 etc until all mailboxes are open.

I get an error message like: Read cell: Column ‘A1’ does not belong to table DataTable.

Can anyone help me solve my problem?

Thanks in advance

Translated with DeepL.com (free version)

2

Are you using a read data activity to read the entrie sheet into a datatable? Can you share the properties of that activity

3

Hi,

for sure

Capture d’écran 2024-10-08 121159
Capture d’écran 2024-10-08 121159545×620 18.3 KB

4

You only need two specific cells from google sheets? - the language is throwing me off here, i apologize.

If so I would change my approach because you are trying to read specific range within a loop which is why you are running into problems.

Try using read cell activity and reference the cell you need, do this for username and pw.

use type into and click activates to enter the referenced cells into the browser activity.

If i’m misunderstand then please correct me and I’ll do my best to help :slight_smile:

cheers

5

I have a lot of information in my google sheet but for the connection I need only 2 Infos (username and pw)
But each line is an another gmail account that’s why I tried with a loop…
When you say “reference the cell” you mean the reference of my colum ?

Thank’s for the tips :wink:

6

If you are seeking a specific cell (like A49) for username and (b49) for password, you can’t use read range as there isn’t a range to read per sey.

Try read cell activity instead of read range and see if that works for you in this use case