kartikoli
Busy!!
I have a lead generation job where we collect data from various sources and add to google sheets but now company wants to use there own database to add leads. The problem we face is its time consuming to add data onto overdrive (company database) so people prefer to work on SS (google spreadsheet) and then copy paste the data to overdrive. Since the layout for each lead is same we have to waste time copy pasting data for each row
Here is the example of the data
Spreadsheet *SNIP*
Overdrive *SNIP*
The first column in spreadsheet have overdrive links (Unique for each row with same layout) so we open the link and start copy pasting rest of the data from the SS to OD. This is a repetitive task so I want to know if we can somehow automate. I don't have any programing background so can't use python which is what people suggested on youtube
Found this extension *SNIP* which does almost exactly what I need but it works for a single page where as I want to open different pages with same layout. Actually if we see the url its just the ID for each account which changes
*SNIP*
*SNIP*
(We can't open those links as we need company login credentials)
Any help would be appreciated as it would saves lots of time for me and my team
Mod edit: Removed potentially sensitive information.
Here is the example of the data
Spreadsheet *SNIP*
Overdrive *SNIP*
The first column in spreadsheet have overdrive links (Unique for each row with same layout) so we open the link and start copy pasting rest of the data from the SS to OD. This is a repetitive task so I want to know if we can somehow automate. I don't have any programing background so can't use python which is what people suggested on youtube
Found this extension *SNIP* which does almost exactly what I need but it works for a single page where as I want to open different pages with same layout. Actually if we see the url its just the ID for each account which changes
*SNIP*
*SNIP*
(We can't open those links as we need company login credentials)
Any help would be appreciated as it would saves lots of time for me and my team
Mod edit: Removed potentially sensitive information.
Last edited by a moderator: