Scenario with Google and Excel

Hello. I’m using Make for the first time and I do not know how it works exactly yet. I need to create a scenario where using an url link of a website a new tab pops up, then with an excel table I need to take out some datas from this excel and put them in the website which I opened with the link before. On this website the datas will be examinated and the results should be sent with an e-mail. I had problems making the first step, I could not find out how I can open a new tab with a google page using a link, is it possible at all? Thank you in advance

1 Like

Hi @Gio_Zeta, That’s a lot of things :slight_smile: .

  1. Where would this link be exactly ? Do you have existing user interface ?
  2. This website we’re being redirected on, is it already developed ? Can you show what the fields look like ?

In Make you can configure a webhook to start the scenario when user clicks on a (1) link/button. The link will be a webhook link. Then we can add excel module to get data, but depending on your (2) website structure, writing in fields is more javascript/html issue with ‘webhook response’ module. Lastly, user will click on a link/button in this (2) website, and start scenario 2 with a webhook to get the data to the scenario and then process. Webhook response can be used lastly to confirm errors/confirmation messages to the user.

Update : to respond to your main question, it’s possible, but you have to configure your link HTML tags on the website. see How to open a URL in a new tab (and not a new window).

Hello @kudracha

Thank you for your reply. Unfortunately I did not find the solution. I will try to explain myself better. For me it is important that I can create a new scenario, the first step is to find the right module, where I can copy the link and then the website opens automatically in a new tab. I tried with the module HTTP (make a request), I copy-pasted the link from a list where I have the important links to work. I ran the module only to see if it everything was all right, and it was, but I expected that the new tab would pop up. My main issue is to find the right module where I can manually copy the link and which allows to open the website in a new tab. The website is already devepoled, it is a national website with notifications about national entreprises.

I hope it is a bit more understable now, I’m sorry for bad explainations but I also have not enough knowledge about such processes automations and their terms and concepts.

Thank you in advance

@Gio_Zeta, Opening a new tab can not be done directly in Make. The button you’re implementing in your first webpage has to be done with html element :

<a href=“https://www.google.comtarget=“_blank”>Google

Where instead of google.com we’ll use a Make Webhook URL. “_target” attribute assures that website will be opened in a new tab.

To explain what webhook does very simply : You can create a scenario and set up very basic webhook (it has to be the first module). To test this, put a second module “Webhook response” and type in any address, like https://google.com . You’ll have 2-module scenario. Copy the URL inside the webhook module and turn on the scenario. This will wait for webhook activation. Open a new tab and paste the URL in your browser and hit enter. You’ll see that you’ll be redirected to Google.