17.07.2024
274

Gemini

Gemini

Integration with Gemini is implemented as a separate AI TOOLS (ChatGPT) block, which can be placed between the Source and Destination of data. This will allow you to create a query based on data from the Data Source and pass data from Gemini to the Data Ingest fields. This way you can automatically receive data from Gemini and transfer it to the services and systems that you use.

The function allows you to create a request in Gemini and send the result of the request to Data Destination.

Navigation:

Connecting Google Sheets as a Data Source:

1. What data can you get from Google Sheets?
2. How to connect your Google Sheets account to ApiX-Drive?
3. Select the table and sheet from which rows will be unloaded.
4. An example of data that will be transferred from Google Sheets.

Connecting Gemini:

1. What data can be obtained from Gemini?
2. How to connect your Gemini account to ApiX-Drive?
3. How to configure data search in Gemini in the selected action?
    Gemini 1.0 Pro
    Gemini 1.5 Flash
    Gemini 1.5 Pro 
4. An example of data that will be transferred from Gemini.  

Setting up row updates in Google Sheets:
1. What will the Google Sheets integration do?
2. How to connect your Google Sheets account to ApiX-Drive?
3. How can I configure the selected action to transfer data to Google Sheets?
4. Example of data that will be sent to your Google Sheets.
5. Auto-update and communication interval.

Setting up Data SOURCE: Google Sheets

Let's look at how the function of requesting data from Gemini and sending the result to Google Sheets works.

First, you need to create a new connection.  

Setting up Gemini in Google Sheets | Creating a connection

Select the system as the Data Source. In this case, you must specify Google Sheets.

Setting up Gemini in Google Sheets | System selection

Next, you need to specify the action "Get ROWS (new)".

Setting up Gemini in Google Sheets | Action selection

The next step is to select the Google Sheets account from which the data will be uploaded.

If there are no logins connected to the system, click "Connect account".    

Setting up Gemini in Google Sheets | Connecting account

Select which account you want to connect to ApiX-Drive and provide all permissions to work with this account.

Setting up Gemini in Google Sheets | Connecting account
Setting up Gemini in Google Sheets | Connecting account
Setting up Gemini in Google Sheets | Connecting account
Setting up Gemini in Google Sheets | Connecting account

When the connected account appears in the "active accounts" list, select it for further work.

Attention! If your account is on the "inactive accounts" list, check your access to this login!

Setting up Gemini in Google Sheets | Account selection

Select the Google Sheets table and sheet where the data you need is located.

Setting up Gemini in Google Sheets | Table and Sheet Selection

If necessary, you can set up a Data Filter, or click "Continue" to skip this step.

To find out how to setup the Data Filter, follow the link: https://apix-drive.com/en/help/data-filter

Setting up Gemini in Google Sheets | Data filter

Now you can see the test data for one of the rows in your Google Sheets.

If you want to update the test data - click "Load test data from Google Sheets".

If you want to change the settings - click "Edit" and you will go back one step.    

Setting up Gemini in Google Sheets | Test data

Now we connect the additional OpenAI block (ChatGPT). To do this, click on “+” and select “AI (GPT-Chat)” from the list.

Setting up Gemini in Google Sheets | Add Gemini block

Setting up Gemini

Select "Gemini" as the system in which the search will be performed.

Setting up Gemini in Google Sheets | System selection

Next, you need to specify the action, for example, "Send PROMPT".

Setting up Gemini in Google Sheets | Action selection

- Send PROMPT - allows you to send a request to Gemini for gerating, editing and translating data.

The next step is to select an Gemini account.

If there are no logins connected to the ApiX-Drive system, click “Connect account”.   

Setting up Gemini in Google Sheets | Connecting account

Select which account you want to connect to ApiX-Drive and provide all permissions to work with this account.

Setting up Gemini in Google Sheets | Account conection
Setting up Gemini in Google Sheets | Account conection
Setting up Gemini in Google Sheets | Account conection

When the connected account appears in the "active accounts" list, select it for further work.

Attention! If your account is on the "inactive accounts" list, check your access to this login!

Setting up Gemini in Google Sheets | Account selection

Now you need to select the Gemini Model. The choice of model depends on your application.

Gemini 1.0 Pro - a family of visually productive multimodal models.

Gemini 1.5 Flash - a family of lightweight models optimized for speed and efficiency. Up to 1,000,000 tokens.

Gemini 1.5 Pro - family of the most productive models in a wide range of tasks. The largest models of all large-scale models, up to 2,000,000 tokens.

Answering Gemini knowledge base questions and generating text

In this case, select "Gemini 1.0 Pro (gemini-1.0-pro)".

Setting up Gemini in Google Sheets | Setting up Gemini
Setting up Gemini in Google Sheets | Setting up Gemini

- Prompt - in this field you need to assign which variable of the Data Source table contains the data for which the query will be made on the Gemini server, in our case, this is column “A”.  
- Presence penalty - This parameter is used to encourage the model to include a variety of tokens in the generated text. This is the value that is subtracted from the log likelihood of the token each time it is generated. A higher Presence Penalty value will cause the model to be more likely to generate tokens that were not already included in the generated text.  
- Temperature - can range from 0 to 2. Higher values such as 0.8 will make the output more random, while lower values such as 0.2 will make it more focused and deterministic.  

Setting up Gemini in Google Sheets | Assigning fields

Now you see test data for your request. You can pass this data to your reception table.

If test data does not appear automatically, click "Search in Gemini".

If you are not satisfied with something, click “Edit”, go back a step and change the search field settings.  

Setting up Gemini in Google Sheets | Test data
Setting up Gemini in Google Sheets | Test data

Generation and editing of text according to the request

In this case, select "Gemini 1.5 Flash (gemini-1.5-flash)".

Setting up Gemini in Google Sheets | Assigning fields

- Prompt - in this field you need to assign which variable of the Data Source table contains the data for which the query will be made on the Gemini server, in our case, this is column “A”.  
- Presence penalty - This parameter is used to encourage the model to include a variety of tokens in the generated text. This is the value that is subtracted from the log likelihood of the token each time it is generated. A higher Presence Penalty value will cause the model to be more likely to generate tokens that were not already included in the generated text.  
- Temperature - can range from 0 to 2. Higher values such as 0.8 will make the output more random, while lower values such as 0.2 will make it more focused and deterministic.    

Setting up Gemini in Google Sheets | Assigning fields
Setting up Gemini in Google Sheets | Assigning fields

Now you see test data for your request. You can pass this data to your reception table.

If test data does not appear automatically, click "Search in Gemini".

If you are not satisfied with something, click “Edit”, go back a step and change the search field settings.    

Setting up Gemini in Google Sheets | Test data
Setting up Gemini in Google Sheets | Test data

Data analysis and structuring

In this case, select "Gemini 1.5 Pro (gemini-1.5-pro)".

Setting up Gemini in Google Sheets | Assigning fields

- Prompt - in this field you need to assign which variable of the Data Source table contains the data for which the query will be made on the Gemini server, in our case, this is column “A”.  
- Presence penalty - This parameter is used to encourage the model to include a variety of tokens in the generated text. This is the value that is subtracted from the log likelihood of the token each time it is generated. A higher Presence Penalty value will cause the model to be more likely to generate tokens that were not already included in the generated text.  
- Temperature - can range from 0 to 2. Higher values such as 0.8 will make the output more random, while lower values such as 0.2 will make it more focused and deterministic.     

Setting up Gemini in Google Sheets | Assigning fields
Setting up Gemini in Google Sheets | Assigning fields

Now you see test data for your request. You can pass this data to your reception table.

If test data does not appear automatically, click "Search in Gemini".

If you are not satisfied with something, click “Edit”, go back a step and change the search field settings.  

Setting up Gemini in Google Sheets | Test data
Setting up Gemini in Google Sheets | Test data
Setting up Gemini in Google Sheets | Test data

This completes the configuration of Gemini data!

Now we can start setting up Google Sheets as a Data Receiver system.

To do this, click "Add Data Destination".

Setting up Gemini in Google Sheets | System selection

Setup Data Destination system: Google Sheets

Select the system as Data Destination. In this case, you must specify Google Sheets.

Setting up Gemini in Google Sheets | System selection

Next, you need to specify the action "Update ROW".

Setting up Gemini in Google Sheets | Action selection

The next step is to select a Google Sheets account into which the result of the Gemini request will be transferred. If this is the same account, then we select it.

If you need to connect another login to the system, click “Connect account” and repeat the same steps described when connecting Google Sheets as a Data Source.  

Setting up Gemini in Google Sheets | Account selection

Now you need to select the File (Table) and Sheet in which the status of Gemini will be updated.

In the "Search column" field, you need to select the column by which the data will be searched. That is, where to look for data in the table.

Next, in the "Search" field, you need to select a variable from the drop-down list or enter the data manually, by which value the system will search for data to update the row you need. In our case, we select column "A", which contains the data about the request. The system will update the data in the desired row only if it matches the requested data.

Also, you need to specify the Search Type, in case several rows with the same query are found:

"Take the first found row" - searching and updating data will occur in the first found row that satisfies the search conditions.

"Take the last found row" - searching and updating data will occur in the last found row that satisfies the search conditions.

"Take all found rows" - search and update of data will be performed on all found rows that satisfy the search conditions.

Now you need to assign a variable with the result of the query, which we take from the Data Search block, to the empty column. In the future, this column will be updated according to your request.

After setting, click "Continue".

Setting up Gemini in Google Sheets | Assigning fields
Setting up Gemini in Google Sheets | Assigning fields

Thus, the Gemini block takes the field in the Data Source in which you have written the request text, queries the OpenAI server (ChatGPT) for the result of this request and transfers this data to the Data Reception field, for example, in column “B”.

Setting up Gemini in Google Sheets | Test data
Setting up Gemini in Google Sheets | Test data

This completes the Data Destination system setup!
Now you can start choosing the update interval and enabling auto-update.
To do this, click "Enable update".        

Setting up Gemini in Google Sheets | Completing setup

On the main screen, click on the gear icon to select the required update interval or set up scheduled launch. To start the connection by time, select scheduled start and specify the desired time for the connection update to fire, or add several options at once when you need the connection to fire.

Attention! In order for the scheduled run to work at the specified time, the interval between the current time and the specified time must be more than 5 minutes. For example, you select the time 12:10 and the current time is 12:08 - in this case, the automatic update of the connection will occur at 12:10 the next day. If you select the time 12:20 and the current time is 12:13 - the auto-update of the connection will work today and then every day at 12:20.

To make the current connection transmit data only after another connection, check the box "Update connection only after start other connection" and specify the connection after which the current connection will be started.     

Setting up Gemini in Google Sheets | Update interval
Setting up Gemini in Google Sheets | Update priority
Setting up Gemini in Google Sheets | Enable auto-update

This completes the setup of Gemini! Everything is quite simple!

Now don't worry, ApiX-Drive will do everything on its own!